Football Stats Made Easy


In this project I hope to be able to simplify the statistics of football players to a point where those who do not follow the sport can statistically say who the best players are and maybe some of the reasons they perform so well.

library(tidyverse)
library(easystats)
library(modelr)
library(ggplot2)
library(janitor)
library(dplyr)
library(knitr)
library(magrittr)
library(kableExtra)
library(h2o)


df <- read_csv("./england-premier-league-players-2018-to-2019-stats.csv") %>% clean_names()

dfMatches <- read_csv("./england-premier-league-matches-2018-to-2019-stats.csv") %>% clean_names()

dfTeams <- read_csv("./england-premier-league-teams-2018-to-2019-stats.csv") %>% clean_names()

2018/2019 Premier League Teams

These are the teams that participated in the Premier League in the 2018 to 2019 season. The Premier league is the best league based in the united kingdom. To make it to the premier league a team must be top 3 in the league in which you are then promoted to the next league and the 3 lowest teams in the league above then get demoted.

AFC Bournemouth

knitr::include_graphics(path = "AFC.png")

AFC <- filter(df, current_club == "AFC Bournemouth") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(AFC, format = "html" ,caption = "Stats for Football Team AFC Bournemouth",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team AFC Bournemouth
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Adam Smith 31 1991-04-29 Defender 2073 England 25 1 1 0 0 9 30 6 1 0.04
Andrew Surman 36 1986-08-20 Midfielder 1438 England 18 0 0 0 0 5 35 2 0 0.00
Artur Boruc 42 1980-02-20 Goalkeeper 1080 Poland 12 0 0 0 0 4 17 2 0 0.00
Asmir Begović 35 1987-06-20 Goalkeeper 2160 Bosnia and Herzegovina 24 0 0 0 0 5 44 0 0 0.00
Callum Wilson 30 1992-02-27 Forward 2535 England 30 14 9 1 1 9 44 3 0 0.50
Charlie Daniels 36 1986-09-07 Defender 1583 England 21 1 0 0 0 6 32 4 0 0.06
Chris Mepham 24 1997-11-05 Defender 849 Wales 13 0 1 0 0 3 16 1 0 0.00
Dan Gosling 32 1990-02-01 Midfielder 1737 England 25 2 1 0 0 7 31 8 0 0.10
David Brooks 25 1997-07-08 Forward 2278 England 30 7 5 0 0 9 39 3 0 0.28
Diego Rico 29 1993-02-23 Defender 607 Spain 12 0 0 0 0 0 18 1 0 0.00
Dominic Solanke 25 1997-09-14 Forward 341 England 10 0 1 0 0 2 4 0 0 0.00
Emerson Hyndman 26 1996-04-09 Midfielder 37 USA 1 0 0 0 0 0 2 0 0 0.00
Jack Simpson 25 1996-12-18 Defender 403 England 6 0 0 0 0 2 9 0 0 0.00
Jefferson Lerma 28 1994-10-25 Midfielder 2511 Colombia 30 2 0 0 0 8 45 12 0 0.07
Jermain Defoe 40 1982-10-07 Forward 21 England 4 0 0 0 0 2 2 0 0 0.00
Jordon Ibe 26 1995-12-08 Midfielder 795 England 19 1 1 0 0 4 21 1 0 0.11
Joshua King 30 1992-01-15 Forward 2974 Norway 35 12 3 5 1 9 54 3 0 0.36
Junior Stanislas 32 1989-11-26 Midfielder 1027 England 23 2 3 1 0 7 24 1 0 0.18
Kyle Taylor 23 1999-08-28 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Lewis Cook 25 1997-02-03 Midfielder 721 England 13 0 0 0 0 3 10 2 0 0.00
Lys Mousset 26 1996-02-08 Forward 345 France 24 1 0 0 0 5 13 1 0 0.26
Marc Pugh 35 1987-04-02 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Mark Travers 23 1999-05-18 Goalkeeper 180 Republic of Ireland 2 0 0 0 0 1 5 0 0 0.00
Matt Butcher 25 1997-05-14 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Nathan Aké 27 1995-02-18 Defender 3412 Netherlands 38 4 0 0 0 10 66 3 0 0.11
Nathaniel Clyne 31 1991-04-05 Defender 1254 England 18 0 1 0 0 6 24 2 0 0.00
Nnamdi Ofoborh 22 1999-11-07 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Ryan Fraser 28 1994-02-24 Midfielder 3173 Scotland 38 7 14 0 0 10 61 2 0 0.20
Sam Surridge 24 1998-07-28 Forward 11 England 2 0 0 0 0 0 0 0 0 0.00
Simon Francis 37 1985-02-16 Defender 1226 England 17 0 2 0 0 5 23 1 0 0.00
Steve Cook 31 1991-04-19 Defender 2787 England 31 1 1 0 0 9 53 3 0 0.03
Tyrone Mings 29 1993-03-13 Defender 141 England 5 0 0 0 0 0 4 0 0 0.00

Arsenal

knitr::include_graphics(path = "./Arsenal.png")

ARS <- filter(df, current_club == "Arsenal") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(ARS, format = "html" ,caption = "Stats for Football Team Arsenal",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Arsenal
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Aaron Ramsey 31 1990-12-26 Midfielder 1327 Wales 28 4 6 0 0 7 12 0 0 0.27
Ainsley Maitland-Niles 25 1997-08-29 Midfielder 985 England 16 1 1 0 0 4 16 3 1 0.09
Alex Iwobi 26 1996-05-03 Forward 1972 Nigeria 35 3 6 0 0 8 31 0 0 0.14
Alexandre Lacazette 31 1991-05-28 Forward 2503 France 35 13 8 0 0 7 28 2 0 0.47
Bernd Leno 30 1992-03-04 Goalkeeper 2835 Germany 32 0 0 0 0 7 39 0 0 0.00
Carl Jenkinson 30 1992-02-08 Defender 166 England 3 0 0 0 0 0 2 0 0 0.00
Damián Emiliano Martínez 30 1992-09-02 Goalkeeper 0 Argentina 0 0 0 0 0 0 0 0 0 0.00
Danny Welbeck 31 1990-11-26 Forward 147 England 8 1 1 0 0 2 2 0 0 0.61
Denis Suárez 28 1994-01-06 Midfielder 67 Spain 4 0 0 0 0 1 0 0 0 0.00
Edward Nketiah 23 1999-05-30 Forward 62 England 5 1 0 0 0 1 2 0 0 1.45
Emile Smith Rowe 22 2000-07-28 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Granit Xhaka 30 1992-09-27 Midfielder 2502 Switzerland 29 4 2 0 0 7 35 10 0 0.14
Hector Bellerin 27 1995-03-19 Defender 1535 Spain 19 0 5 0 0 4 20 3 0 0.00
Henrikh Mkhitaryan 33 1989-01-21 Midfielder 1643 Armenia 25 6 4 0 0 4 25 1 0 0.33
Joseph Willock 23 1999-08-20 Midfielder 64 England 2 0 0 0 0 0 0 0 0 0.00
Konstantinos Mavropanos 24 1997-12-11 Defender 150 Greece 4 0 0 0 0 1 1 1 0 0.00
Laurent Koscielny 37 1985-09-10 Defender 1328 France 17 3 0 0 0 4 21 1 0 0.20
Lucas Torreira 26 1996-02-11 Midfielder 2377 Uruguay 34 2 2 0 0 6 35 8 1 0.08
Mattéo Guendouzi Olié 23 1999-04-14 Midfielder 2143 France 33 0 0 0 0 4 28 9 0 0.00
Mesut Özil 34 1988-10-15 Midfielder 1741 Germany 24 5 2 0 0 6 23 2 0 0.26
Mohamed Elneny 30 1992-07-11 Midfielder 381 Egypt 8 0 0 0 0 2 4 0 0 0.00
Nacho Monreal 36 1986-02-26 Defender 1861 Spain 22 1 3 0 0 6 21 5 0 0.05
Petr Čech 40 1982-05-20 Goalkeeper 585 Czech Republic 7 0 0 0 0 2 8 0 0 0.00
Pierre-Emerick Aubameyang 33 1989-06-18 Forward 2731 Gabon 36 22 5 4 1 8 40 0 0 0.73
Rob Holding 27 1995-09-20 Defender 807 England 10 0 0 0 0 2 10 1 0 0.00
Sead Kolašinac 29 1993-06-20 Defender 1891 Bosnia and Herzegovina 24 0 5 0 0 5 26 5 0 0.00
Shkodran Mustafi 30 1992-04-17 Defender 2617 Germany 31 2 0 0 0 6 36 9 0 0.07
Sokratis Papastathopoulos 34 1988-06-09 Defender 2199 Greece 25 1 2 0 0 6 31 12 0 0.04
Stephan Lichtsteiner 38 1984-01-16 Defender 940 Switzerland 14 0 0 0 0 2 18 3 0 0.00
Zechariah Medley 22 2000-07-07 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00

Brighton & Hove Albion

knitr::include_graphics(path = "./Brighton&HoveAlbion.png")

BHA <- filter(df, current_club == "Brighton & Hove Albion") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(BHA, format = "html" ,caption = "Stats for Football Team Brighton & Hove Albion",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Brighton & Hove Albion
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Alireza Jahanbakhsh 29 1993-08-11 Forward 1022 Iran 19 0 0 0 0 4 16 2 0 0.00
Anthony Knockaert 30 1991-11-20 Midfielder 1832 France 30 2 6 0 0 3 36 5 1 0.10
Ben White 25 1997-10-08 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Beram Kayal 34 1988-05-02 Midfielder 934 Israel 18 1 1 0 0 5 15 4 0 0.10
Bernardo 27 1995-05-14 Defender 1750 Brazil 22 0 1 0 0 4 28 4 0 0.00
Bruno Saltor Grau 42 1980-10-01 Defender 1136 Spain 14 0 1 0 0 4 17 2 0 0.00
Dale Stephens 33 1989-06-12 Midfielder 2487 England 30 1 1 0 0 5 43 7 1 0.04
Dan Burn 30 1992-05-09 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
David Button 33 1989-02-27 Goalkeeper 360 England 4 0 0 0 0 1 5 0 0 0.00
Davy Pröpper 31 1991-09-02 Midfielder 2551 Netherlands 30 1 1 0 0 5 44 2 0 0.04
Florin Andone 29 1993-04-11 Forward 874 Romania 23 3 0 0 0 3 13 5 0 0.31
Gaëtan Bong Songo 34 1988-04-25 Defender 1805 Cameroon 22 0 0 0 0 5 32 0 0 0.00
Glenn Murray 39 1983-09-25 Forward 2513 England 38 13 1 4 0 7 44 5 0 0.47
Jason Steele 32 1990-08-18 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Jayson Molumby 23 1999-08-06 Midfielder 0 Republic of Ireland 0 0 0 0 0 0 0 0 0 0.00
Jose Izquierdo 30 1992-07-07 Forward 794 Colombia 15 0 1 0 0 5 8 1 0 0.00
Jürgen Locadia 28 1993-11-07 Forward 1227 Netherlands 26 2 0 0 0 4 19 1 0 0.15
Leon Balogun 34 1988-06-28 Defender 591 Nigeria 8 1 0 0 0 0 9 2 0 0.15
Lewis Dunk 30 1991-11-21 Defender 3153 England 36 2 1 0 0 7 53 7 1 0.06
Markus Suttner 35 1987-04-16 Defender 0 Austria 0 0 0 0 0 0 0 0 0 0.00
Martín Montoya 31 1991-04-14 Defender 2166 Spain 25 0 1 0 0 3 38 4 0 0.00
Mathew Ryan 30 1992-04-08 Goalkeeper 3060 Australia 34 0 0 0 0 6 52 2 0 0.00
Max Harrison Sanders 23 1999-01-04 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Pascal Groß 31 1991-06-15 Midfielder 1878 Germany 25 3 3 1 1 3 31 1 0 0.14
Shane Duffy 30 1992-01-01 Defender 3088 Republic of Ireland 35 5 1 0 0 7 51 5 1 0.15
Solomon March 28 1994-07-20 Midfielder 2473 England 35 1 5 0 0 6 39 1 0 0.04
Viktor Gyökeres 24 1998-06-04 Forward 0 Sweden 0 0 0 0 0 0 0 0 0 0.00
Yves Bissouma 26 1996-08-30 Midfielder 1769 Mali 28 0 0 0 0 5 30 5 0 0.00

Burnley

knitr::include_graphics(path = "./Burnley.png")

BNL <- filter(df, current_club == "Burnley") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(BNL, format = "html" ,caption = "Stats for Football Team Burnley",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Burnley
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Aaron Lennon 35 1987-04-16 Midfielder 1217 England 16 1 1 0 0 4 20 1 0 0.07
Ali Koiki 22 2000-08-22 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Anthony Driscoll-Glennon 22 1999-11-26 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Ashley Barnes 32 1989-10-30 Forward 2400 England 37 12 2 2 0 8 34 8 0 0.45
Ashley Westwood 32 1990-04-01 Midfielder 2822 England 34 2 7 0 0 7 44 5 0 0.06
Ben Gibson 29 1993-01-15 Defender 63 England 1 1 0 0 0 0 3 1 0 1.43
Ben Mee 33 1989-09-21 Defender 3420 England 38 0 2 0 0 8 57 9 0 0.00
Charlie Taylor 29 1993-09-18 Defender 3240 England 38 0 1 0 0 8 53 2 0 0.00
Chris Wood 30 1991-12-07 Forward 2582 New Zealand 38 10 2 0 0 8 43 2 0 0.35
Dwight McNeil 22 1999-11-22 Forward 1599 England 21 3 5 0 0 4 22 2 0 0.17
Jack Cork 33 1989-06-25 Midfielder 3313 England 37 1 2 0 0 8 54 6 0 0.03
James Tarkowski 29 1992-11-19 Defender 3087 England 35 3 1 0 0 7 52 8 0 0.09
Jeff Hendrick 30 1992-01-31 Midfielder 2069 Republic of Ireland 32 3 0 0 0 6 41 4 0 0.13
Joe Hart 35 1987-04-19 Goalkeeper 1710 England 19 0 0 0 0 4 34 0 0 0.00
Johann Berg Guðmunds­son 32 1990-10-27 Midfielder 1748 Iceland 29 3 6 0 0 6 31 2 0 0.15
Jonathan Walters 39 1983-09-20 Forward 0 Republic of Ireland 0 0 0 0 0 0 0 0 0 0.00
Josh Benson 22 1999-12-05 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Kevin Long 32 1990-08-18 Defender 513 Republic of Ireland 6 0 1 0 0 1 7 0 0 0.00
Matěj Vydra 30 1992-05-01 Forward 311 Czech Republic 13 1 1 0 0 1 4 1 0 0.29
Matthew Lowton 33 1989-06-09 Defender 1748 England 21 0 0 0 0 4 35 7 0 0.00
Peter Crouch 41 1981-01-30 Forward 86 England 6 0 0 0 0 0 0 1 0 0.00
Phil Bardsley 37 1985-06-28 Defender 1672 Scotland 19 0 0 0 0 4 22 9 0 0.00
Robbie Brady 30 1992-01-14 Midfielder 715 Republic of Ireland 16 0 1 0 0 2 12 4 1 0.00
Sam Vokes 33 1989-10-21 Forward 913 Wales 20 3 0 0 0 4 18 0 0 0.30
Stephen Ward 37 1985-08-20 Defender 230 Republic of Ireland 3 0 0 0 0 1 6 1 0 0.00
Steven Defour 34 1988-04-15 Midfielder 452 Belgium 6 0 0 0 0 1 12 0 0 0.00
Tom Heaton 36 1986-04-15 Goalkeeper 1710 England 19 0 0 0 0 4 23 3 0 0.00

Cardiff City

knitr::include_graphics(path = "./CardiffCity.png")

CFC <- filter(df, current_club == "Cardiff City") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(CFC, format = "html" ,caption = "Stats for Football Team Cardiff City",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Cardiff City
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Alex Smithies 32 1990-03-05 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Aron Einar Gunnarsson 33 1989-04-22 Midfielder 2274 Iceland 28 1 1 0 0 8 37 5 0 0.04
Bobby Reid 29 1993-02-02 Midfielder 1422 England 27 5 2 1 0 6 27 0 0 0.32
Brian Murphy 39 1983-05-07 Goalkeeper 0 Republic of Ireland 0 0 0 0 0 0 0 0 0 0.00
Bruno Écuélé Manga 34 1988-07-16 Defender 3375 Gabon 38 0 1 0 0 10 59 0 0 0.00
Callum Paterson 28 1994-10-13 Defender 1996 Scotland 27 4 1 0 0 7 37 4 0 0.18
Danny Ward 31 1990-12-09 Forward 440 England 14 1 0 0 0 2 11 0 0 0.20
David Junior Hoilett 32 1990-06-05 Forward 2142 Canada 32 3 1 0 0 9 42 4 0 0.13
Gary Madine 32 1990-08-24 Forward 32 England 5 0 0 0 0 0 2 0 0 0.00
Greg Cunningham 31 1991-01-31 Defender 630 Republic of Ireland 7 0 0 0 0 1 16 3 0 0.00
Harry Arter 32 1989-12-28 Midfielder 2008 Republic of Ireland 25 0 1 0 0 7 37 10 0 0.00
Jazz Richards 31 1991-04-12 Defender 128 Wales 4 0 0 0 0 1 4 0 0 0.00
Joe Bennett 32 1990-03-28 Defender 2641 England 30 0 1 0 0 9 43 5 0 0.00
Joe Ralls 29 1993-10-13 Midfielder 1959 England 28 0 0 0 1 8 35 5 1 0.00
Josh Murphy 27 1995-02-24 Forward 1825 England 29 3 2 0 0 7 27 2 0 0.15
Kadeem Harris 29 1993-06-08 Midfielder 366 England 13 1 0 0 0 4 5 1 0 0.25
Kenneth Dahrup Zohorè 28 1994-01-31 Forward 746 Denmark 19 1 1 0 0 5 15 1 0 0.12
Leandro Bacuna 31 1991-08-21 Midfielder 554 Curaçao 11 0 0 0 0 4 11 2 0 0.00
Lee Peltier 35 1986-12-11 Defender 1542 England 20 0 0 0 0 6 21 4 0 0.00
Loïc Damour 31 1991-01-08 Midfielder 21 France 2 0 0 0 0 0 2 0 0 0.00
Matthew Connolly 35 1987-09-24 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Nathaniel Mendez-Laing 30 1992-04-15 Midfielder 984 England 20 4 1 1 0 6 15 0 0 0.37
Neil Leonard Dula Etheridge 32 1990-02-07 Goalkeeper 3420 Philippines 38 0 0 0 0 10 61 2 0 0.00
Oumar Niasse 32 1990-04-18 Forward 998 Senegal 18 0 0 0 0 3 12 0 0 0.00
Rhys Healey 27 1994-12-06 Forward 49 England 3 0 0 0 0 1 1 0 0 0.00
Sean Morrison 31 1991-01-08 Defender 3040 England 34 1 3 0 0 9 57 6 0 0.03
Souleymane Bamba 37 1985-01-13 Defender 2475 Ivory Coast 28 4 1 0 0 7 46 7 0 0.15
Víctor Camarasa 28 1994-05-28 Midfielder 2579 Spain 32 5 4 1 0 8 48 6 0 0.17

Chelsea

knitr::include_graphics(path = "./Chelsea.png")

CHS <- filter(df, current_club == "Chelsea") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(CHS, format = "html" ,caption = "Stats for Football Team Chelsea",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Chelsea
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Alvaro Morata 30 1992-10-23 Forward 943 Spain 16 5 0 0 0 9 11 3 0 0.48
Andreas Christensen 26 1996-04-10 Defender 615 Denmark 8 0 0 0 0 3 7 1 0 0.00
Antonio Rüdiger 29 1993-03-03 Defender 2874 Germany 33 1 0 0 0 12 34 7 0 0.03
Callum Hudson-Odoi 21 2000-11-07 Midfielder 391 England 10 0 1 0 0 3 5 0 0 0.00
Cesar Azpilicueta 33 1989-08-28 Defender 3403 Spain 38 1 5 0 0 16 38 4 0 0.03
Cesc Fabregas 35 1987-05-04 Midfielder 175 Spain 6 0 0 0 0 3 2 1 0 0.00
Danny Drinkwater 32 1990-03-05 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
David Luiz 35 1987-04-22 Defender 3239 Brazil 36 3 2 0 0 16 35 3 0 0.08
Davide Zappacosta 30 1992-06-11 Defender 125 Italy 4 0 0 0 0 3 0 0 0 0.00
Eden Hazard 31 1991-01-07 Midfielder 2926 Belgium 37 16 15 4 0 15 34 2 0 0.49
Emerson Palmieri dos Santos 28 1994-08-03 Defender 660 Italy 10 0 0 0 0 3 10 0 0 0.00
Ethan Ampadu 22 2000-09-14 Midfielder 0 Wales 0 0 0 0 0 0 0 0 0 0.00
Gary Cahill 36 1985-12-19 Defender 22 England 2 0 0 0 0 2 0 0 0 0.00
Gonzalo Higuain 34 1987-12-10 Forward 1092 Argentina 14 5 0 0 0 5 15 0 0 0.41
Jorginho 30 1991-12-20 Midfielder 3165 Italy 37 2 0 1 0 16 36 8 0 0.06
Kepa Arrizabalaga 28 1994-10-03 Goalkeeper 3240 Spain 36 0 0 0 0 14 38 2 0 0.00
Marc Guehi 22 2000-07-13 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Marcos Alonso 31 1990-12-28 Defender 2761 Spain 31 2 4 0 0 14 28 6 0 0.07
Mateo Kovačić 28 1994-05-06 Midfielder 1743 Croatia 32 0 2 0 0 12 18 3 0 0.00
N’Golo Kanté 31 1991-03-29 Midfielder 3096 France 36 4 4 0 0 15 37 3 0 0.12
Olivier Giroud 36 1986-09-30 Forward 832 France 27 2 4 0 0 12 4 1 0 0.22
Pedro Rodriguez 35 1987-07-28 Midfielder 1780 Spain 31 8 2 0 0 11 18 2 0 0.40
Ross Barkley 28 1993-12-05 Midfielder 1241 England 27 3 5 0 0 11 13 1 0 0.22
Ruben Loftus-Cheek 26 1996-01-23 Midfielder 983 England 24 6 2 0 0 12 8 0 0 0.55
Victor Moses 31 1990-12-12 Midfielder 26 Nigeria 2 0 0 0 0 1 1 0 0 0.00
Wilfredo Daniel Caballero 41 1981-09-28 Goalkeeper 180 Argentina 2 0 0 0 0 2 0 0 0 0.00
Willian 34 1988-08-09 Forward 2108 Brazil 32 3 6 0 0 13 23 2 0 0.13

Crystal Palace

knitr::include_graphics(path = "./CrystalPalace.png")

CRP <- filter(df, current_club == "Crystal Palace") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(CRP, format = "html" ,caption = "Stats for Football Team Crystal Palace",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Crystal Palace
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Aaron Wan-Bissaka 24 1997-11-26 Midfielder 3135 England 35 0 3 0 0 12 41 5 1 0.00
Alexander Sørloth 26 1995-12-05 Forward 173 Norway 12 0 0 0 0 4 1 0 0 0.00
Andros Townsend 31 1991-07-16 Midfielder 3018 England 38 6 4 0 0 12 44 1 0 0.18
Bakary Sako 34 1988-04-26 Midfielder 25 Mali 4 0 0 0 0 1 0 0 0 0.00
Cheikhou Kouyaté 32 1989-12-21 Midfielder 1897 Senegal 31 0 2 0 0 11 24 3 0 0.00
Christian Benteke 31 1990-12-03 Forward 813 Belgium 16 1 1 0 0 5 10 1 0 0.11
Connor Wickham 29 1993-03-31 Forward 61 England 6 0 1 0 0 2 0 0 0 0.00
Jaïro Riedewald 26 1996-09-09 Defender 0 Netherlands 0 0 0 0 0 0 0 0 0 0.00
James McArthur 35 1987-10-07 Midfielder 3071 Scotland 38 3 6 0 0 12 44 7 0 0.09
James Tomkins 33 1989-03-29 Defender 2563 England 29 1 1 0 0 10 34 6 0 0.04
Jeffrey Schlupp 29 1992-12-23 Defender 1665 Ghana 30 4 1 0 0 8 24 1 0 0.22
Joe Daniel Tupper 24 1997-11-15 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Joel Ward 32 1989-10-29 Defender 551 England 7 1 0 0 0 0 12 1 0 0.16
Jordan Ayew 31 1991-09-11 Forward 1186 Ghana 20 1 2 0 0 6 13 3 0 0.08
Julián Speroni 43 1979-05-18 Goalkeeper 90 Argentina 1 0 0 0 0 0 3 0 0 0.00
Luka Milivojević 31 1991-04-07 Midfielder 3420 Serbia 38 12 2 10 1 12 47 10 0 0.32
Luke Dreher 23 1998-11-27 Midfielder 0 England 1 0 0 0 0 0 0 0 0 0.00
Mamadou Sakho 32 1990-02-13 Defender 2417 France 27 0 0 0 0 9 32 2 0 0.00
Martin Kelly 32 1990-04-27 Defender 1110 England 13 0 0 0 0 3 18 2 0 0.00
Max Meyer 27 1995-09-18 Midfielder 1414 Germany 29 1 2 0 0 8 19 3 0 0.06
Michy Batshuayi 29 1993-10-02 Forward 756 Belgium 11 5 0 0 0 3 11 0 0 0.60
Nikola Tavares 23 1999-01-17 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Pape N’Diaye Souaré 32 1990-06-06 Defender 0 Senegal 1 0 0 0 0 1 0 0 0 0.00
Patrick van Aanholt 32 1990-08-29 Defender 3198 Netherlands 36 3 2 0 0 12 41 3 0 0.08
Sam Woods 24 1998-09-11 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Scott Dann 35 1987-02-14 Defender 660 England 10 0 1 0 0 3 7 1 0 0.00
Sullay Kaikai 27 1995-08-26 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Vicente Guaita 35 1987-01-10 Goalkeeper 1755 Spain 20 0 0 0 0 7 21 2 0 0.00
Wayne Hennessey 35 1987-01-24 Goalkeeper 1575 Wales 18 0 0 0 0 5 23 0 0 0.00
Wilfried Zaha 29 1992-11-10 Midfielder 3041 Ivory Coast 34 10 5 0 0 10 45 10 1 0.30

Everton

knitr::include_graphics(path = "./Everton.png")

EVN <- filter(df, current_club == "Everton") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(EVN, format = "html" ,caption = "Stats for Football Team Everton",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Everton
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Ademola Lookman 25 1997-10-20 Forward 601 England 21 0 2 0 0 8 7 0 0 0.00
André Filipe Tavares Gomes 29 1993-07-30 Midfielder 1986 Portugal 27 1 1 0 0 10 27 7 0 0.05
Bernard Anício Caldeira Duarte 30 1992-09-08 Midfielder 2128 Brazil 34 1 3 0 0 14 19 5 0 0.04
Cenk Tosun 31 1991-06-07 Forward 1050 Turkey 25 3 3 0 0 7 16 3 0 0.26
Dominic Calvert-Lewin 25 1997-03-16 Forward 1774 England 35 6 2 0 0 13 24 3 0 0.30
Gylfi Sigurdsson 33 1989-09-08 Midfielder 3134 Iceland 38 13 6 2 3 14 40 3 0 0.37
Idrissa Gana Gueye 33 1989-09-26 Midfielder 2825 Senegal 33 0 2 0 0 13 29 6 0 0.00
James McCarthy 31 1990-11-12 Midfielder 14 Republic of Ireland 1 0 0 0 0 1 0 0 0 0.00
Jonjoe Kenny 25 1997-03-15 Defender 790 England 10 0 1 0 0 2 14 1 0 0.00
Jordan Pickford 28 1994-03-07 Goalkeeper 3420 England 38 0 0 0 0 14 44 1 0 0.00
Kieran Dowell 25 1997-10-10 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Kurt Zouma 28 1994-10-27 Defender 2610 France 32 2 2 0 0 11 37 5 1 0.07
Leighton Baines 37 1984-12-11 Defender 376 England 6 0 0 0 0 1 6 0 0 0.00
Lucas Digne 29 1993-07-20 Defender 2990 France 35 4 4 0 0 14 36 6 1 0.12
Maarten Stekelenburg 40 1982-09-22 Goalkeeper 0 Netherlands 0 0 0 0 0 0 0 0 0 0.00
Mason Holgate 26 1996-10-22 Defender 407 England 5 0 0 0 0 0 9 1 0 0.00
Michael Keane 29 1993-01-11 Defender 2970 England 33 1 2 0 0 13 37 2 0 0.03
Morgan Schneiderlin 32 1989-11-08 Midfielder 833 France 14 0 1 0 0 7 9 2 0 0.00
Phil Jagielka 40 1982-08-17 Defender 329 England 7 1 0 0 0 5 2 1 1 0.27
Richarlison de Andrade 25 1997-05-10 Forward 2679 Brazil 35 13 1 0 0 14 32 6 1 0.44
Sandro Ramirez 27 1995-07-09 Forward 0 Spain 0 0 0 0 0 0 0 0 0 0.00
Séamus Coleman 34 1988-10-11 Defender 2560 Republic of Ireland 29 2 2 0 0 13 29 1 0 0.07
Theo Walcott 33 1989-03-16 Forward 2122 England 37 5 2 0 0 13 33 1 0 0.21
Tom Davies 24 1998-06-30 Midfielder 975 England 16 0 0 0 0 5 18 3 0 0.00
Tyias Browning 28 1994-05-27 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Yerry Fernando Mina González 28 1994-09-23 Defender 890 Colombia 13 1 0 0 0 4 12 3 0 0.10

Fulham

knitr::include_graphics(path = "./Fulham.png")

FLM <- filter(df, current_club == "Fulham") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(FLM, format = "html" ,caption = "Stats for Football Team Fulham",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Fulham
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Aboubakar Kamara 27 1995-03-07 Forward 687 France 13 3 0 1 1 2 16 2 0 0.39
Aleksandar Mitrović 28 1994-09-16 Forward 3282 Serbia 37 11 3 1 0 5 74 7 0 0.30
Alfie Mawson 28 1994-01-19 Defender 1131 England 15 0 0 0 0 3 25 2 0 0.00
André Schürrle 31 1990-11-06 Midfielder 1650 Germany 24 6 0 0 0 1 42 2 0 0.33
André-Frank Zambo Anguissa 26 1995-11-16 Midfielder 1518 Cameroon 22 0 0 0 0 3 30 3 1 0.00
Calum Chambers 27 1995-01-20 Defender 2587 England 31 2 0 0 0 5 49 9 0 0.07
Cyrus Christie 30 1992-09-30 Defender 1943 Republic of Ireland 28 0 1 0 0 5 40 7 0 0.00
Denis Odoi 34 1988-05-27 Defender 2593 Belgium 31 0 1 0 0 5 59 4 0 0.00
Fabricio Martín Agosto Ramírez 34 1987-12-31 Goalkeeper 180 Spain 2 0 0 0 0 0 5 0 0 0.00
Floyd Ayité 33 1988-12-15 Midfielder 465 Togo 16 1 0 0 0 3 13 0 0 0.19
Håvard Nordtveit 32 1990-06-21 Midfielder 361 Norway 5 0 1 0 0 1 9 0 0 0.00
Ibrahima Cissé 28 1994-02-28 Midfielder 87 Belgium 3 0 0 0 0 0 3 0 0 0.00
Jean Michau00ebl Seri 31 1991-07-19 Midfielder 2252 Ivory Coast 32 1 2 0 0 4 53 6 0 0.04
Joe Bryan 29 1993-09-17 Defender 2350 England 28 0 1 0 0 5 51 5 0 0.00
Kevin McDonald 33 1988-11-04 Midfielder 842 Scotland 15 0 0 0 0 0 25 6 1 0.00
Lazar Marković 28 1994-03-02 Midfielder 44 Serbia 1 0 0 0 0 0 0 0 0 0.00
Luca de la Torre 24 1998-05-23 Midfielder 0 USA 0 0 0 0 0 0 0 0 0 0.00
Luciano Vietto 28 1993-12-05 Forward 983 Argentina 20 1 4 0 0 1 21 1 0 0.09
Marcus Bettinelli 30 1992-05-24 Goalkeeper 630 England 7 0 0 0 0 0 19 1 0 0.00
Maxime Le Marchand 33 1989-10-11 Defender 2251 France 26 0 1 0 0 4 50 5 0 0.00
Neeskens Kebano 30 1992-03-10 Midfielder 103 Congo DR 7 0 0 0 0 0 1 0 0 0.00
Ryan Guno Babel 35 1986-12-19 Forward 1260 Netherlands 16 5 3 0 0 3 24 3 0 0.36
Ryan Sessegnon 22 2000-05-18 Defender 2298 England 35 2 6 0 0 4 58 0 0 0.08
Sergio Rico 29 1993-09-01 Goalkeeper 2610 Spain 29 0 0 0 0 5 53 1 0 0.00
Stefan Marius Johansen 31 1991-01-08 Midfielder 412 Norway 12 0 0 0 0 0 11 4 0 0.00
Tim Ream 35 1987-10-05 Defender 2051 USA 26 0 0 0 0 5 47 1 0 0.00
Timothy Fosu-Mensah 24 1998-01-02 Defender 795 Netherlands 12 0 0 0 0 1 18 3 0 0.00
Tom Cairney 31 1991-01-20 Midfielder 2198 Scotland 31 1 1 0 0 4 49 0 0 0.04
Zeze Steven Sessegnon 22 2000-05-18 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00

Huddersfield Town

knitr::include_graphics(path = "./Huddersfield_Town.png")

HFT <- filter(df, current_club == "Huddersfield Town") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(HFT, format = "html" ,caption = "Stats for Football Team Huddersfield Town",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Huddersfield Town
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Aaron Mooy 32 1990-09-15 Midfielder 2327 Australia 29 3 1 1 0 4 46 4 0 0.12
Aaron Rowe 22 2000-09-07 Forward 69 England 2 0 0 0 0 0 1 0 0 0.00
Abdelhamid Sabiri 25 1996-11-28 Midfielder 49 Morocco 2 0 0 0 0 0 3 0 0 0.00
Adama Diakhaby 26 1996-07-05 Forward 551 France 12 0 0 0 0 1 16 1 0 0.00
Alex Pritchard 29 1993-05-03 Midfielder 2092 England 30 2 0 0 0 4 39 2 0 0.09
Ben Hamer 34 1987-11-20 Goalkeeper 553 England 7 0 0 0 0 1 20 0 0 0.00
Chris Löwe 33 1989-04-16 Defender 2056 Germany 29 0 2 0 0 1 52 2 0 0.00
Christopher Schindler 32 1990-04-29 Defender 3262 Germany 37 1 0 0 0 5 69 6 1 0.03
Collin Quaner 31 1991-06-18 Forward 37 Germany 2 0 0 0 0 0 2 0 0 0.00
Daniel Williams 33 1989-03-08 Midfielder 93 USA 5 0 0 0 0 1 1 1 0 0.00
Demeaco Duhaney 24 1998-10-13 Defender 46 England 1 0 0 0 0 1 0 0 0 0.00
Elias Kachunga 30 1992-04-22 Forward 1181 Congo DR 20 0 0 0 0 2 28 2 0 0.00
Erik Durm 30 1992-05-12 Defender 2052 Germany 28 0 1 0 0 3 43 0 0 0.00
Florent Hadergjonaj 28 1994-07-31 Defender 1840 Switzerland 24 0 0 0 0 4 34 1 0 0.00
Isaac Mbenza 26 1996-03-08 Forward 981 Belgium 22 1 1 0 0 4 25 1 0 0.09
Jason Puncheon 36 1986-06-26 Midfielder 391 England 11 0 0 0 0 3 8 1 0 0.00
Joel Coleman 27 1995-09-26 Goalkeeper 90 England 1 0 0 0 0 0 1 0 0 0.00
Jon Gorenc Stankovič 26 1996-01-14 Defender 718 Slovenia 11 1 0 0 0 2 19 2 0 0.13
Jonas Lössl 33 1989-02-01 Goalkeeper 2777 Denmark 31 0 1 0 0 5 52 1 0 0.00
Jonathan Hogg 33 1988-12-06 Midfielder 2377 England 29 0 1 0 0 5 42 9 1 0.00
Juninho Bacuna 25 1997-08-07 Midfielder 1414 Netherlands 21 1 0 0 0 2 36 4 0 0.06
Karlan Ahearne-Grant 24 1997-12-19 Forward 874 England 13 4 0 0 0 1 22 0 0 0.41
Laurent Depoitre 33 1988-12-07 Forward 1059 Belgium 23 0 1 0 0 3 22 1 0 0.00
Mathias Jattah-Njie Jørgensen 32 1990-04-23 Defender 2148 Denmark 24 3 1 0 0 3 37 6 0 0.13
Matty Daly 21 2001-03-10 Midfielder 73 England 2 0 0 0 0 0 1 0 0 0.00
Philip Billing 26 1996-06-11 Midfielder 2192 Denmark 27 2 0 0 0 5 41 7 0 0.08
Rajiv van La Parra 31 1991-06-04 Midfielder 407 Netherlands 5 0 0 0 0 1 6 0 0 0.00
Ramadan Sobhi 25 1997-01-23 Forward 75 Egypt 4 0 0 0 0 0 1 0 0 0.00
Ryan Schofield 22 1999-12-11 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Steve Mounié 28 1994-09-29 Forward 1777 Benin 31 2 3 0 0 5 34 2 1 0.10
Terence Kongolo 28 1994-02-14 Defender 2722 Netherlands 32 1 1 0 0 4 62 4 0 0.03
Tom Smith 30 1992-04-14 Defender 1141 England 15 0 0 0 0 1 34 3 1 0.00

Leicester City

knitr::include_graphics(path = "./Leicester_City.png")

LSC <- filter(df, current_club == "Leicester City") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(LSC, format = "html" ,caption = "Stats for Football Team Leicester City",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Leicester City
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Adrien Sebastian Perruchet Silva 33 1989-03-15 Midfielder 88 Portugal 2 0 0 0 0 1 1 0 0 0.00
Ben Chilwell 25 1996-12-21 Defender 3240 England 36 0 4 0 0 10 39 4 0 0.00
Caglar Söyüncü 26 1996-05-23 Defender 371 Turkey 6 0 0 0 0 2 3 1 0 0.00
Christian Fuchs 36 1986-04-07 Defender 206 Austria 3 0 0 0 0 0 4 0 0 0.00
Daniel Amartey 27 1994-12-21 Midfielder 640 Ghana 9 0 0 0 0 2 9 2 0 0.00
Danny Simpson 35 1987-01-04 Defender 291 England 6 0 0 0 0 3 4 0 0 0.00
Danny Ward 29 1993-06-22 Goalkeeper 0 Wales 0 0 0 0 0 0 0 0 0 0.00
Demarai Gray 26 1996-06-28 Midfielder 1992 England 34 4 1 0 0 8 26 2 0 0.18
Fousseni Diabaté 27 1995-10-18 Midfielder 55 Mali 1 0 0 0 0 0 1 0 0 0.00
Hamza Choudhury 25 1997-10-01 Midfielder 596 England 9 0 0 0 0 4 4 0 0 0.00
Harry Maguire 29 1993-03-05 Defender 2599 England 31 3 0 0 0 7 36 7 1 0.10
Harvey Lewis Barnes 24 1997-12-09 Midfielder 1007 England 16 1 2 0 0 3 16 0 0 0.09
James Maddison 25 1996-11-23 Midfielder 2850 England 36 7 7 1 1 8 39 5 1 0.22
Jamie Vardy 35 1987-01-11 Forward 2735 England 34 18 4 4 1 10 33 4 1 0.59
Jonny Evans 34 1988-01-03 Defender 1995 Northern Ireland 24 1 0 0 0 8 22 2 0 0.05
Josh Knight 25 1997-09-07 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Kasper Schmeichel 35 1986-11-05 Goalkeeper 3420 Denmark 38 0 0 0 0 10 43 3 0 0.00
Kelechi Iheanacho 26 1996-10-03 Forward 926 Nigeria 30 1 3 0 0 6 11 2 0 0.10
Marc Albrighton 32 1989-11-18 Midfielder 1626 England 27 2 2 0 0 9 17 3 0 0.11
Nampalys Mendy 30 1992-06-23 Midfielder 2088 France 31 0 0 0 0 9 26 5 0 0.00
Onyinye Wilfred Ndidi 25 1996-12-16 Midfielder 3299 Nigeria 38 2 0 0 0 10 42 8 0 0.05
Rachid Ghezzal 30 1992-05-09 Forward 738 Algeria 19 1 0 0 0 3 12 3 0 0.12
Ricardo Domingos Barbosa Pereira 29 1993-10-06 Defender 3125 Portugal 35 2 6 0 0 10 40 7 0 0.06
Shinji Okazaki 36 1986-04-16 Forward 269 Japan 21 0 1 0 0 2 1 0 0 0.00
Vicente Iborra De La Fuente 34 1988-01-16 Midfielder 226 Spain 8 0 0 0 0 3 4 0 0 0.00
Wes Morgan 38 1984-01-21 Defender 1926 Jamaica 22 3 0 0 0 6 24 5 2 0.14
Youri Tielemans 25 1997-05-07 Midfielder 1092 Belgium 13 3 4 0 0 3 13 2 0 0.25

Liverpool

knitr::include_graphics(path = "./Liverpool_FC.png")

LVP <- filter(df, current_club == "Liverpool") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(LVP, format = "html" ,caption = "Stats for Football Team Liverpool ",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Liverpool
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Adam David Lallana 34 1988-05-10 Midfielder 465 England 13 0 0 0 0 6 2 1 0 0.00
Alberto Moreno 30 1992-07-05 Defender 155 Spain 2 0 0 0 0 0 2 0 0 0.00
Alex Oxlade-Chamberlain 29 1993-08-15 Midfielder 19 England 2 0 0 0 0 2 0 0 0 0.00
Alisson Becker 30 1992-10-02 Goalkeeper 3420 Brazil 38 0 0 0 0 21 19 1 0 0.00
Andrew Robertson 28 1994-03-11 Defender 3219 Scotland 36 0 11 0 0 21 17 4 0 0.00
Curtis Jones 21 2001-01-30 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Daniel Sturridge 33 1989-09-01 Forward 496 England 18 2 1 0 0 10 3 1 0 0.36
Dejan Lovren 33 1989-07-05 Defender 985 Croatia 13 1 0 0 0 6 7 1 0 0.09
Divock Origi 27 1995-04-18 Forward 366 Belgium 12 3 1 0 0 7 2 0 0 0.74
Fabinho 29 1993-10-23 Midfielder 2013 Brazil 28 1 2 0 0 15 13 6 0 0.04
Georginio Wijnaldum 31 1990-11-11 Midfielder 2735 Netherlands 35 3 0 0 0 21 15 3 0 0.10
James Milner 36 1986-01-04 Midfielder 1785 England 31 5 4 3 0 18 11 7 1 0.25
Joe Gomez 25 1997-05-23 Defender 1060 England 16 0 0 0 0 11 3 2 0 0.00
Joel Matip 31 1991-08-08 Defender 1532 Cameroon 22 1 0 0 0 11 9 3 0 0.06
Jordan Henderson 32 1990-06-17 Midfielder 1983 England 32 1 3 0 0 19 11 3 1 0.05
Loris Karius 29 1993-06-22 Goalkeeper 0 Germany 0 0 0 0 0 0 0 0 0 0.00
Mohamed Salah 30 1992-06-15 Forward 3262 Egypt 38 22 8 3 0 21 18 1 0 0.61
Naby Deco Keïta 27 1995-02-10 Midfielder 1392 Guinea 25 2 1 0 0 15 7 0 0 0.13
Rafael Euclides Soares Camacho 22 2000-05-22 Midfielder 0 Portugal 1 0 0 0 0 0 0 0 0 0.00
Roberto Firmino 31 1991-10-02 Forward 2620 Brazil 34 12 6 1 0 18 13 0 0 0.41
Sadio Mané 30 1992-04-10 Forward 3086 Senegal 36 22 1 0 0 20 18 2 0 0.64
Simon Mignolet 34 1988-03-06 Goalkeeper 0 Belgium 0 0 0 0 0 0 0 0 0 0.00
Trent Alexander-Arnold 24 1998-10-07 Defender 2467 England 29 1 12 0 0 16 14 3 0 0.04
Virgil van Dijk 31 1991-07-08 Defender 3385 Netherlands 38 4 2 0 0 21 19 1 0 0.11
Xherdan Shaqiri 31 1991-10-10 Midfielder 1058 Switzerland 24 6 3 0 0 12 5 2 0 0.51

Manchester City

knitr::include_graphics(path = "./Manchester_City.png")

MCC <- filter(df, current_club == "Manchester City") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(MCC, format = "html" ,caption = "Stats for Football Team Manchester City",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Manchester City
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Arijanet Muric 23 1998-11-07 Goalkeeper 0 Montenegro 0 0 0 0 0 0 0 0 0 0.00
Aymeric Laporte 28 1994-05-27 Defender 3057 France 35 3 3 0 0 18 21 3 0 0.09
Benjamin Mendy 28 1994-07-17 Defender 900 France 10 0 5 0 0 4 6 1 0 0.00
Bernardo Silva 28 1994-08-10 Midfielder 2853 Portugal 36 7 7 0 0 18 22 3 0 0.22
Claudio Andrés Bravo Muñoz 39 1983-04-13 Goalkeeper 0 Chile 0 0 0 0 0 0 0 0 0 0.00
Danilo 31 1991-07-15 Defender 806 Brazil 11 1 0 0 0 5 7 1 0 0.11
David Silva 36 1986-01-08 Midfielder 2411 Spain 33 6 8 0 0 17 14 3 0 0.22
Ederson 29 1993-08-17 Goalkeeper 3420 Brazil 38 0 1 0 0 20 23 2 0 0.00
Fabian Delph 32 1989-11-21 Midfielder 725 England 11 0 1 0 0 4 9 2 1 0.00
Fernando Luiz Rosa 37 1985-05-04 Midfielder 2381 Brazil 29 1 3 0 0 16 15 5 0 0.04
Gabriel Jesus 25 1997-04-03 Forward 1019 Brazil 29 7 3 1 0 16 11 1 0 0.62
İlkay Gündoğan 32 1990-10-24 Midfielder 2135 Germany 31 6 3 0 0 15 15 3 0 0.25
John Stones 28 1994-05-28 Defender 1762 England 24 0 0 0 0 13 15 1 0 0.00
Kevin De Bruyne 31 1991-06-28 Midfielder 974 Belgium 19 2 2 0 0 12 3 2 0 0.18
Kyle Walker 32 1990-05-28 Defender 2777 England 33 1 1 0 0 18 17 3 0 0.03
Leroy Sané 26 1996-01-11 Midfielder 1867 Germany 31 10 10 0 0 16 14 1 0 0.48
Nicolas Otamendi 34 1988-02-12 Defender 1233 Argentina 18 0 0 0 0 10 7 1 0 0.00
Oleksandr Zinchenko 25 1996-12-15 Midfielder 1153 Ukraine 14 0 3 0 0 10 4 1 0 0.00
Philip Foden 22 2000-05-28 Midfielder 327 England 13 1 0 0 0 8 0 0 0 0.28
Philippe Sandler 25 1997-02-10 Defender 0 Netherlands 0 0 0 0 0 0 0 0 0 0.00
Raheem Sterling 27 1994-12-08 Forward 2777 England 34 17 10 0 0 18 19 3 0 0.55
Riyad Mahrez 31 1991-02-21 Midfielder 1339 Algeria 27 7 4 0 1 13 9 0 0 0.47
Sergio Aguero 34 1988-06-02 Forward 2480 Argentina 33 21 8 2 0 19 15 3 0 0.76
Vincent Kompany 36 1986-04-10 Defender 1223 Belgium 17 1 0 0 0 7 7 6 0 0.07

Manchester United

knitr::include_graphics(path = "./Manchester_United.png")

MCU <- filter(df, current_club == "Manchester United") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(MCU, format = "html" ,caption = "Stats for Football Team Manchester United",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Manchester United
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Alexis Sanchez 33 1988-12-19 Forward 877 Chile 20 1 3 0 0 6 8 3 0 0.10
Ander Herrera 33 1989-08-14 Midfielder 1404 Spain 22 2 3 0 0 6 17 4 0 0.13
Andreas Pereira 26 1996-01-01 Midfielder 595 Brazil 15 1 1 0 0 1 10 5 0 0.15
Angel Gomes 22 2000-08-31 Midfielder 25 England 2 0 0 0 0 0 1 0 0 0.00
Anthony Martial 26 1995-12-05 Forward 1623 France 27 10 2 1 0 5 25 2 0 0.55
Antonio Valencia 37 1985-08-04 Defender 466 Ecuador 6 0 0 0 0 2 5 2 0 0.00
Ashley Young 37 1985-07-09 Midfielder 2568 England 30 2 2 0 0 4 41 10 1 0.07
Chris Smalling 32 1989-11-22 Defender 2128 England 24 1 0 0 0 4 34 1 0 0.04
David de Gea 31 1990-11-07 Goalkeeper 3420 Spain 38 0 0 0 0 7 51 1 0 0.00
Eric Bertrand Bailly 28 1994-04-12 Defender 637 Ivory Coast 12 0 0 0 0 3 12 1 1 0.00
Faustino Marcos Alberto Rojo 32 1990-03-20 Defender 211 Argentina 5 0 0 0 0 0 4 2 0 0.00
Frederico Rodrigues Santos 29 1993-03-05 Midfielder 1045 Brazil 17 1 1 0 0 0 19 2 0 0.09
James Garner 21 2001-03-13 Defender 0 England 1 0 0 0 0 0 0 0 0 0.00
Jesse Lingard 29 1992-12-15 Midfielder 1668 England 27 4 2 1 0 6 25 3 0 0.22
José Diogo Dalot Teixeira 23 1999-03-18 Defender 1015 Portugal 16 0 2 0 0 2 18 3 0 0.00
Juan Mata 34 1988-04-28 Midfielder 1294 Spain 22 3 2 0 0 4 14 3 0 0.21
Lee Grant 39 1983-01-27 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Luke Shaw 27 1995-07-12 Defender 2592 England 29 1 4 0 0 6 36 11 0 0.03
Marcus Rashford 25 1997-10-31 Forward 2362 England 33 10 6 0 0 6 34 4 1 0.38
Marouane Fellaini 34 1987-11-22 Midfielder 744 Belgium 14 0 1 0 0 2 13 1 0 0.00
Mason Greenwood 21 2001-10-01 Midfielder 115 England 3 0 0 0 0 0 2 0 0 0.00
Matteo Darmian 32 1989-12-02 Defender 443 Italy 6 0 0 0 0 1 7 0 0 0.00
Nemanja Matić 34 1988-08-01 Midfielder 2441 Serbia 28 1 0 0 0 6 35 8 1 0.04
Paul Pogba 29 1993-03-15 Midfielder 3011 France 35 13 9 7 3 7 41 6 0 0.39
Phil Jones 30 1992-02-21 Defender 1263 England 18 0 1 0 0 4 16 1 0 0.00
Romelu Lukaku 29 1993-05-13 Forward 2130 Belgium 32 12 0 0 0 7 36 4 0 0.51
Scott McTominay 25 1996-12-08 Midfielder 861 England 16 2 0 0 0 3 17 1 0 0.21
Sergio Germán Romero 35 1987-02-22 Goalkeeper 0 Argentina 0 0 0 0 0 0 0 0 0 0.00
Tahith Chong 22 1999-12-04 Forward 36 Netherlands 2 0 0 0 0 0 1 0 0 0.00
Victor Nilsson Lindelöf 28 1994-07-17 Defender 2602 Sweden 30 1 1 0 0 6 38 1 0 0.03

Newcastle United

knitr::include_graphics(path = "./Newcastle_United.png")

NCU <- filter(df, current_club == "Newcastle United") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(NCU, format = "html" ,caption = "Stats for Football Team Newcastle United",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Newcastle United
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Antonio Barreca 27 1995-03-18 Defender 4 Italy 1 0 0 0 0 0 0 0 0 0.00
Ayoze Perez 29 1993-07-29 Forward 2929 Spain 37 12 2 0 0 11 34 2 0 0.37
Callum Roberts 25 1997-04-14 Forward 0 England 0 0 0 0 0 0 0 0 0 0.00
Christian Atsu Twasam 30 1992-01-10 Midfielder 1487 Ghana 28 1 0 0 0 8 16 2 0 0.06
Ciaran Clark 33 1989-09-26 Defender 857 Republic of Ireland 11 3 0 0 0 2 14 1 0 0.32
DeAndre Yedlin 29 1993-07-09 Defender 2475 USA 29 1 2 0 0 6 37 7 1 0.04
Fabian Schär 30 1991-12-20 Defender 2002 Switzerland 24 4 1 0 0 8 21 12 0 0.18
Federico Fernández 33 1989-02-21 Defender 1484 Argentina 19 0 1 0 0 4 22 2 0 0.00
Florian Lejeune 31 1991-05-20 Defender 1055 France 12 0 0 0 0 3 12 0 0 0.00
Freddie Woodman 25 1997-03-04 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Isaac Hayden 27 1995-03-22 Midfielder 1886 England 25 1 4 0 0 7 25 4 1 0.05
Jacob Murphy 27 1995-02-24 Midfielder 300 England 9 0 1 0 0 1 7 0 0 0.00
Jamal Lascelles 28 1993-11-11 Defender 2748 England 32 0 1 0 0 11 33 4 0 0.00
Jamie Sterry 26 1995-11-21 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Javier Manquillo Gaitán 28 1994-05-05 Defender 1097 Spain 18 0 3 0 0 6 12 2 0 0.00
Jonjo Shelvey 30 1992-02-27 Midfielder 944 England 16 1 1 0 0 5 11 1 0 0.10
José Luis Sanmartín Mato 32 1990-03-27 Forward 586 Spain 16 2 0 0 0 4 12 1 0 0.31
Karl Darlow 32 1990-10-08 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Kelland Watts 23 1999-11-03 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Lewis Cass 22 2000-02-27 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Martin Dúbravka 33 1989-01-15 Goalkeeper 3420 Slovakia 38 0 0 0 0 11 44 1 0 0.00
Matt Ritchie 33 1989-09-10 Midfielder 2940 Scotland 36 2 8 1 1 11 37 9 0 0.06
Miguel Ángel Almirón Rejala 28 1994-02-10 Midfielder 763 Paraguay 10 0 0 0 0 3 10 0 0 0.00
Mohamed Diamé 35 1987-06-14 Midfielder 2165 Senegal 29 0 0 0 0 9 28 3 0 0.00
Paul Dummett 31 1991-09-26 Defender 1986 Wales 26 0 0 0 0 9 27 1 0 0.00
Robert Kenedy Nunes do Nascimento 26 1996-02-08 Midfielder 1344 Brazil 25 1 1 0 1 8 17 1 0 0.07
Rondon 33 1989-09-16 Forward 2609 Venezuela 32 11 7 0 0 10 29 1 0 0.38
Sean Longstaff 25 1997-10-30 Midfielder 688 England 9 1 0 0 0 3 8 2 0 0.13
Sung-Yeung Ki 33 1989-01-24 Midfielder 1302 South Korea 18 0 1 0 0 5 18 2 0 0.00
Yoshinori Muto 30 1992-07-15 Forward 516 Japan 17 1 0 0 0 5 10 1 0 0.17

Southampton

knitr::include_graphics(path = "./Southampton.png")

SHN <- filter(df, current_club == "Southampton") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(SHN, format = "html" ,caption = "Stats for Football Team Southampton",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Southampton
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Alex McCarthy 32 1989-12-03 Goalkeeper 2250 England 25 0 0 0 0 4 37 1 0 0.00
Alfie Jones 25 1997-10-07 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Angus Gunn 26 1996-01-22 Goalkeeper 1080 England 12 0 0 0 0 3 17 0 0 0.00
Callum Slattery 23 1999-02-08 Midfielder 110 England 3 0 0 0 0 0 0 0 0 0.00
Cedric Soares 31 1991-08-31 Defender 1494 Portugal 18 1 2 0 0 5 26 4 0 0.06
Charlie Austin 33 1989-07-05 Forward 980 England 25 2 2 0 1 6 14 1 0 0.18
Daniel William John Ings 30 1992-07-23 Forward 1668 England 24 7 3 3 0 6 26 1 0 0.38
Fraser Forster 34 1988-03-17 Goalkeeper 90 England 1 0 0 0 0 0 3 0 0 0.00
Jack Stephens 28 1994-01-27 Defender 1697 England 24 1 0 0 0 5 30 4 0 0.05
James Ward-Prowse 27 1994-11-01 Midfielder 1942 England 26 7 0 1 0 4 36 4 0 0.32
Jan Bednarek 26 1996-04-12 Defender 2151 Poland 25 0 1 0 0 3 33 7 0 0.00
Jannik Vestergaard 30 1992-08-03 Defender 2030 Denmark 23 0 0 0 0 4 27 2 0 0.00
Joshua Sims 25 1997-03-28 Midfielder 209 England 7 0 1 0 0 1 5 0 0 0.00
Kayne Ramsey 22 2000-10-10 Midfielder 90 England 1 0 0 0 0 0 3 0 0 0.00
Manolo Gabbiadini 30 1991-11-26 Forward 470 Italy 12 1 0 0 0 3 11 0 0 0.19
Mario Lemina 29 1993-09-01 Midfielder 1615 Gabon 21 1 1 0 0 4 32 5 0 0.06
Matt Targett 27 1995-09-18 Defender 1185 England 16 1 3 0 0 1 24 2 0 0.08
Maya Yoshida 34 1988-08-24 Defender 1520 Japan 17 0 1 0 0 3 27 0 0 0.00
Michael Obafemi 22 2000-07-06 Forward 134 Republic of Ireland 6 1 1 0 0 0 2 1 0 0.67
Mohamed Elyounoussi 28 1994-08-04 Midfielder 790 Norway 16 0 0 0 0 4 8 0 0 0.00
Nathan Redmond 28 1994-03-06 Midfielder 3276 England 38 6 4 0 0 7 53 3 0 0.16
Oriol Romeu 31 1991-09-24 Midfielder 2140 Spain 31 1 0 0 0 6 32 11 0 0.04
Pierre-Emile Højbjerg 27 1995-08-05 Midfielder 2764 Denmark 31 4 3 0 0 4 52 10 2 0.13
Ryan Bertrand 33 1989-08-05 Defender 2160 England 24 1 0 0 0 6 36 8 0 0.04
Sam Gallagher 27 1995-09-15 Forward 30 England 4 0 0 0 0 1 0 0 0 0.00
Shane Long 35 1987-01-22 Forward 1269 Republic of Ireland 26 5 1 0 0 5 20 3 0 0.35
Steven Davis 37 1985-01-01 Midfielder 96 Northern Ireland 3 0 1 0 0 0 3 0 0 0.00
Stuart Armstrong 30 1992-03-30 Midfielder 1432 Scotland 29 3 2 0 0 4 23 2 0 0.19
Tyreke Johnson 24 1998-11-03 Defender 0 England 1 0 0 0 0 0 0 0 0 0.00
Wesley Hoedt 28 1994-03-06 Defender 1170 Netherlands 13 0 0 0 0 4 20 2 0 0.00
Yann Valery 23 1999-02-22 Defender 1715 France 23 2 1 0 0 3 26 5 1 0.10

Tottenham Hotspur

knitr::include_graphics(path = "./Tottenham_Hotspur.png")

THR <- filter(df, current_club == "Tottenham Hotspur") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(THR, format = "html" ,caption = "Stats for Football Team Tottenham Hotspur",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Tottenham Hotspur
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Alfie Whiteman 24 1998-10-02 Goalkeeper 0 England 0 0 0 0 0 0 0 0 0 0.00
Ben Davies 29 1993-04-24 Defender 1839 Wales 27 0 0 0 0 10 24 2 0 0.00
Christian Eriksen 30 1992-02-14 Midfielder 2772 Denmark 35 8 12 0 0 10 34 3 0 0.26
Danny Rose 32 1990-07-02 Defender 1806 England 26 0 3 0 0 10 12 5 0 0.00
Davinson Sánchez Mina 26 1996-06-12 Defender 1943 Colombia 23 1 1 0 0 6 21 2 0 0.05
Dele Alli 26 1996-04-11 Midfielder 1827 England 25 5 3 0 0 7 17 4 0 0.25
Eric Dier 28 1994-01-15 Midfielder 1510 England 20 3 0 0 0 6 16 4 0 0.18
Erik Lamela 30 1992-03-04 Midfielder 971 Argentina 19 4 2 0 0 5 11 2 0 0.37
Fernando Llorente Torres 37 1985-02-26 Forward 683 Spain 20 1 4 0 0 7 8 2 0 0.13
George Marsh 23 1998-11-05 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Georges-Kevin N’Koudou Mbida 27 1995-02-13 Forward 4 France 1 0 1 0 0 0 0 0 0 0.00
Harry Kane 29 1993-07-28 Forward 2427 England 28 17 4 4 0 10 28 5 0 0.63
Harry Winks 26 1996-02-02 Midfielder 1591 England 26 1 0 0 0 10 16 4 0 0.06
Heung-Min Son 30 1992-07-08 Forward 2048 South Korea 31 12 6 0 0 11 20 3 1 0.53
Hugo Lloris 35 1986-12-26 Goalkeeper 2970 France 33 0 0 0 0 12 30 0 0 0.00
Jan Vertonghen 35 1987-04-24 Defender 1915 Belgium 22 1 0 0 0 7 21 5 1 0.05
Juan Marcos Foyth 24 1998-01-12 Defender 930 Argentina 12 1 0 0 0 4 10 4 1 0.10
Kazaiah Sterling 23 1998-11-09 Forward 0 England 0 0 0 0 0 0 0 0 0 0.00
Kieran Trippier 32 1990-09-19 Defender 2278 England 27 1 3 0 0 10 20 2 0 0.04
Kyle Walker-Peters 25 1997-04-13 Defender 374 England 6 0 3 0 0 3 4 1 0 0.00
Lucas Rodrigues Moura da Silva 30 1992-08-13 Midfielder 2127 Brazil 32 10 0 0 0 12 16 3 0 0.42
Luke Amos 25 1997-02-23 Midfielder 2 England 1 0 0 0 0 0 0 0 0 0.00
Michel Vorm 39 1983-10-20 Goalkeeper 180 Netherlands 2 0 0 0 0 0 4 0 0 0.00
Moussa Dembele 35 1987-07-16 Midfielder 516 Belgium 10 0 0 0 0 3 5 1 0 0.00
Moussa Sissoko 33 1989-08-16 Midfielder 2336 France 29 0 3 0 0 11 26 2 0 0.00
Oliver Skipp 22 2000-09-16 Midfielder 216 England 8 0 0 0 0 4 0 0 0 0.00
Paulo Dino Gazzaniga 30 1992-01-02 Goalkeeper 270 Argentina 3 0 0 0 0 1 1 0 0 0.00
Serge Aurier 29 1992-12-24 Defender 564 Ivory Coast 8 0 2 0 0 3 9 1 0 0.00
Timothy Eyoma 22 2000-01-29 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Toby Alderweireld 33 1989-03-02 Defender 2924 Belgium 34 0 0 0 0 12 28 3 0 0.00
Victor Wanyama 31 1991-06-25 Midfielder 509 Kenya 13 1 0 0 0 6 3 2 0 0.18
Vincent Janssen 28 1994-06-15 Forward 36 Netherlands 3 0 0 0 0 1 0 0 0 0.00

Watford

knitr::include_graphics(path = "./watford-fc-logo-png-transparent.png")

WFD <- filter(df, current_club == "Watford") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(WFD, format = "html" ,caption = "Stats for Football Team Watford",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Watford
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Abdoulaye Doucouré 29 1993-01-01 Midfielder 3062 France 35 5 6 0 0 5 54 7 0 0.15
Adalberto Peñaranda Maestre 25 1997-05-31 Forward 0 Venezuela 0 0 0 0 0 0 0 0 0 0.00
Adam Masina 28 1994-01-02 Defender 1003 Italy 14 0 1 0 0 2 19 5 0 0.00
Adrian Mariappa 36 1986-10-03 Defender 1921 Jamaica 26 0 0 0 0 6 29 3 0 0.00
Andre Gray 31 1991-06-26 Forward 1358 England 29 7 2 0 0 5 23 2 0 0.46
Ben Foster 39 1983-04-03 Goalkeeper 3420 England 38 0 0 0 0 7 57 1 0 0.00
Ben Wilmot 23 1999-11-04 Defender 26 England 2 0 0 0 0 1 2 0 0 0.00
Christian Kabasele 31 1991-02-24 Defender 1587 Belgium 21 0 0 0 0 4 25 4 1 0.00
Craig Cathcart 33 1989-02-06 Defender 3099 Northern Ireland 36 3 0 0 0 6 52 2 0 0.09
Daryl Janmaat 33 1989-07-22 Defender 1521 Netherlands 18 0 2 0 0 3 22 3 0 0.00
Domingos Quina 22 1999-11-18 Midfielder 335 Portugal 8 1 0 0 0 1 5 0 0 0.27
Etienne Capoue 34 1988-07-11 Midfielder 2947 France 33 1 3 0 0 7 47 15 1 0.03
Francisco Femenía Far 31 1991-02-02 Midfielder 2045 Spain 29 1 1 0 0 5 38 1 0 0.04
Gerard Deulofeu 28 1994-03-13 Forward 2082 Spain 30 10 5 0 0 6 28 3 0 0.43
Heurelho da Silva Gomes 41 1981-02-15 Goalkeeper 0 Brazil 0 0 0 0 0 0 0 0 0 0.00
Isaac Ajayi Success 26 1996-01-07 Forward 1037 Nigeria 30 1 1 0 0 5 20 4 0 0.09
José Holebas 38 1984-06-27 Defender 2394 Greece 28 3 6 0 0 5 38 13 1 0.11
Ken Sema 29 1993-09-30 Midfielder 755 Sweden 17 1 2 0 0 6 8 1 0 0.12
Marc Navarro Ceciliano 27 1995-07-02 Defender 84 Spain 2 0 0 0 0 0 2 0 0 0.00
Miguel Ángel Britos Cabrera 37 1985-07-17 Defender 185 Uruguay 3 0 0 0 0 1 5 0 0 0.00
Nathaniel Chalobah 27 1994-12-12 Midfielder 266 England 9 0 0 0 0 1 5 2 0 0.00
Roberto Maximiliano Pereyra 31 1991-01-07 Forward 2825 Argentina 33 6 1 0 0 5 52 3 0 0.19
Sebastian Prödl 35 1987-06-21 Defender 13 Austria 1 0 0 0 0 1 0 0 0 0.00
Stefano Okaka 33 1989-08-09 Forward 22 Italy 2 0 0 0 0 0 1 1 0 0.00
Tom Cleverley 33 1989-08-12 Midfielder 470 England 13 1 0 0 0 4 7 2 0 0.19
Troy Deeney 34 1988-06-29 Forward 2548 England 32 9 5 1 0 5 43 5 1 0.32
Will Hughes 27 1995-04-17 Midfielder 2436 England 32 2 4 0 0 5 39 5 0 0.07

West Ham United

knitr::include_graphics(path = "./West_Ham.png")

WHU <- filter(df, current_club == "West Ham United") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(WHU, format = "html" ,caption = "Stats for Football Team West Ham United",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team West Ham United
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Aaron Cresswell 32 1989-12-15 Defender 1589 England 20 0 1 0 0 3 22 1 0 0.00
Adrián San Miguel del Castillo 35 1987-01-03 Goalkeeper 0 Spain 0 0 0 0 0 0 0 0 0 0.00
Alexandre Nascimento Costa Silva 25 1997-03-16 Forward 17 Portugal 1 0 0 0 0 0 0 0 0 0.00
Andriy Yarmolenko 33 1989-10-23 Forward 459 Ukraine 9 2 0 0 0 1 4 2 0 0.39
Andy Carroll 33 1989-01-06 Forward 454 England 12 0 0 0 0 2 6 2 0 0.00
Angelo Ogbonna 34 1988-05-23 Defender 1870 Italy 24 1 1 0 0 3 32 2 0 0.05
Arthur Masuaku 28 1993-11-07 Defender 1756 France 23 0 1 0 0 6 26 2 0 0.00
Benjamin Johnson 22 2000-01-24 Forward 63 England 1 0 0 0 0 0 1 0 0 0.00
Carlos Sánchez 36 1986-02-06 Midfielder 240 Colombia 7 0 0 0 0 2 2 0 0 0.00
Conor Coventry 22 2000-03-25 Midfielder 0 Republic of Ireland 0 0 0 0 0 0 0 0 0 0.00
Declan Rice 23 1999-01-14 Midfielder 3005 Republic of Ireland 34 2 0 0 0 6 42 4 0 0.06
Fabián Cornelio Balbuena González 31 1991-08-23 Defender 2014 Paraguay 23 1 0 0 0 5 27 2 0 0.04
Felipe Anderson Pereira Gomes 29 1993-04-15 Midfielder 3054 Brazil 36 9 4 0 0 6 43 3 0 0.27
Grady Diangana 24 1998-04-19 Midfielder 604 England 17 0 1 0 0 2 11 0 0 0.00
Issa Diop 25 1997-01-09 Defender 2970 France 33 1 0 0 0 7 38 4 0 0.03
Jack Wilshere 30 1992-01-01 Midfielder 389 England 8 0 1 0 0 2 8 2 0 0.00
Javier Hernandez 34 1988-06-01 Forward 1335 Mexico 25 7 1 0 0 3 16 2 0 0.47
Joe Powell 24 1998-10-30 Forward 0 England 0 0 0 0 0 0 0 0 0 0.00
Lucas Perez 34 1988-09-10 Forward 468 Spain 15 3 0 0 0 3 9 0 0 0.58
Manuel Lanzini 29 1993-02-15 Midfielder 688 Argentina 10 1 1 0 0 2 11 2 0 0.13
Mark Noble 35 1987-05-08 Midfielder 2308 England 31 5 5 4 0 7 29 7 1 0.19
Marko Arnautović 33 1989-04-19 Forward 2000 Austria 28 10 4 1 0 5 31 3 0 0.45
Michail Antonio 32 1990-03-28 Midfielder 2099 England 33 6 4 0 0 5 26 3 0 0.26
Nathan Holland 24 1998-06-19 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Pablo Zabaleta 37 1985-01-16 Defender 2092 Argentina 26 0 1 0 0 4 32 4 0 0.00
Pedro Obiang 30 1992-03-27 Midfielder 1121 Equatorial Guinea 24 0 1 0 0 7 17 0 0 0.00
Robert Snodgrass 35 1987-09-07 Midfielder 2222 Scotland 33 2 5 0 0 6 31 10 0 0.08
Ryan Fredericks 30 1992-10-10 Midfielder 1085 England 15 1 0 0 0 3 13 5 0 0.08
Samir Nasri 35 1987-06-26 Midfielder 246 France 5 0 2 0 0 1 2 0 0 0.00
Łukasz Fabiański 37 1985-04-18 Goalkeeper 3420 Poland 38 0 0 0 0 7 48 0 0 0.00

Wolverhampton Wanderers

knitr::include_graphics(path = "./Wolverhampton.png")

WHW <- filter(df, current_club == "Wolverhampton Wanderers") %>% select(c('full_name','age','birthday_gmt','position', 'minutes_played_overall','nationality','appearances_overall','goals_overall','assists_overall','penalty_goals','penalty_misses','clean_sheets_overall','conceded_overall','yellow_cards_overall','red_cards_overall','goals_per_90_overall'))

kable(WHW, format = "html" ,caption = "Stats for Football Team Wolverhampton Wanderers",align = "cccccccccccccccc") %>% kable_styling()
Stats for Football Team Wolverhampton Wanderers
full_name age birthday_gmt position minutes_played_overall nationality appearances_overall goals_overall assists_overall penalty_goals penalty_misses clean_sheets_overall conceded_overall yellow_cards_overall red_cards_overall goals_per_90_overall
Adama Traoré Diarra 26 1996-01-25 Midfielder 890 Spain 29 1 1 0 0 6 11 1 0 0.10
Bright Enobakhare 24 1998-02-08 Forward 0 England 0 0 0 0 0 0 0 0 0 0.00
Cameron John 23 1999-08-24 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Conor Coady 29 1993-02-25 Midfielder 3420 England 38 0 0 0 0 9 43 5 0 0.00
Diogo José Teixeira da Silva 25 1996-12-04 Midfielder 2371 Portugal 33 9 5 0 0 9 29 11 0 0.34
Hélder Wander Sousa Azevedo Costa 28 1994-01-12 Midfielder 1345 Portugal 25 1 2 0 0 5 18 3 0 0.07
Ivan Ricardo Neves Abreu Cavaleiro 29 1993-10-18 Forward 683 Portugal 23 3 1 0 0 5 10 1 0 0.40
João Moutinho 36 1986-09-08 Midfielder 3040 Portugal 38 1 8 0 0 9 37 4 0 0.03
John Ruddy 36 1986-10-24 Goalkeeper 90 England 1 0 0 0 0 1 0 0 0 0.00
Jonny 28 1994-03-03 Defender 2780 Spain 33 1 1 0 0 8 36 6 0 0.03
Kortney Hause 27 1995-07-16 Defender 0 England 0 0 0 0 0 0 0 0 0 0.00
Leander Dendoncker 27 1995-04-15 Midfielder 1469 Belgium 19 2 0 0 0 4 19 1 0 0.12
Leonardo Bonatini Lohner Maia 28 1994-03-28 Forward 128 Brazil 7 0 1 0 0 3 0 0 0 0.00
Matt Doherty 30 1992-01-16 Defender 3147 Republic of Ireland 38 4 5 0 0 9 38 5 0 0.11
Max Kilman 25 1997-05-23 Defender 0 England 1 0 0 0 0 1 0 0 0 0.00
Morgan Gibbs-White 22 2000-01-27 Midfielder 647 England 26 0 1 0 0 5 9 1 0 0.00
Raúl Alonso Jiménez Rodríguez 31 1991-05-05 Forward 3124 Mexico 38 13 7 2 0 9 39 4 0 0.37
Romain Saïss 32 1990-03-26 Midfielder 1144 Morocco 19 2 0 0 0 4 16 7 0 0.16
Rúben Diogo Da Silva Neves 25 1997-03-13 Midfielder 3009 Portugal 35 4 3 2 0 8 40 8 0 0.12
Rúben Gonçalo Silva Nascimento Vinagre 23 1999-04-09 Defender 703 Portugal 17 0 0 0 0 5 9 1 0 0.00
Rui Pedro dos Santos Patrício 34 1988-02-15 Goalkeeper 3330 Portugal 37 0 0 0 0 8 43 0 0 0.00
Ryan Bennett 32 1990-03-06 Defender 3060 England 34 1 0 0 0 9 36 12 0 0.03
Ryan Giles 22 2000-01-26 Midfielder 0 England 0 0 0 0 0 0 0 0 0 0.00
Will Norris 29 1993-08-12 Goalkeeper 0 England 1 0 0 0 0 1 0 0 0 0.00
Willy Boly 31 1991-02-03 Defender 3169 France 36 4 0 0 0 8 38 3 1 0.11

Best Forward

A forward is praised by their ability to show up, get goals, and work with those around them to get goals.

Forward <- filter(df, rank_in_league_top_attackers != -1) %>% 
  select(c('full_name','goals_overall','assists_overall','position','current_club','age','birthday_gmt', 'rank_in_league_top_attackers', 'appearances_overall' )) 

ForwardClean <- Forward[order(Forward$rank_in_league_top_attackers),]

kable(ForwardClean, format = "html" , caption = "Top league Forwards",align = "cccccccccccccccc") %>% kable_styling()
Top league Forwards
full_name goals_overall assists_overall position current_club age birthday_gmt rank_in_league_top_attackers appearances_overall
Sergio Aguero 21 8 Forward Manchester City 34 1988-06-02 1 33
Divock Origi 3 1 Forward Liverpool 27 1995-04-18 2 12
Pierre-Emerick Aubameyang 22 5 Forward Arsenal 33 1989-06-18 3 36
Sadio Mané 22 1 Forward Liverpool 30 1992-04-10 4 36
Harry Kane 17 4 Forward Tottenham Hotspur 29 1993-07-28 5 28
Gabriel Jesus 7 3 Forward Manchester City 25 1997-04-03 6 29
Mohamed Salah 22 8 Forward Liverpool 30 1992-06-15 7 38
Michy Batshuayi 5 0 Forward Crystal Palace 29 1993-10-02 8 11
Jamie Vardy 18 4 Forward Leicester City 35 1987-01-11 9 34
Lucas Perez 3 0 Forward West Ham United 34 1988-09-10 10 15
Ruben Loftus-Cheek 6 2 Midfielder Chelsea 26 1996-01-23 11 24
Raheem Sterling 17 10 Forward Manchester City 27 1994-12-08 12 34
Anthony Martial 10 2 Forward Manchester United 26 1995-12-05 13 27
Heung-Min Son 12 6 Forward Tottenham Hotspur 30 1992-07-08 14 31
Xherdan Shaqiri 6 3 Midfielder Liverpool 31 1991-10-10 15 24
Romelu Lukaku 12 0 Forward Manchester United 29 1993-05-13 16 32
Callum Wilson 14 9 Forward AFC Bournemouth 30 1992-02-27 17 30
Eden Hazard 16 15 Midfielder Chelsea 31 1991-01-07 18 37
Leroy Sané 10 10 Midfielder Manchester City 26 1996-01-11 19 31
Alvaro Morata 5 0 Forward Chelsea 30 1992-10-23 20 16
Alexandre Lacazette 13 8 Forward Arsenal 31 1991-05-28 21 35
Riyad Mahrez 7 4 Midfielder Manchester City 31 1991-02-21 22 27
Javier Hernandez 7 1 Forward West Ham United 34 1988-06-01 23 25
Glenn Murray 13 1 Forward Brighton & Hove Albion 39 1983-09-25 24 38
Andre Gray 7 2 Forward Watford 31 1991-06-26 25 29
Marko Arnautović 10 4 Forward West Ham United 33 1989-04-19 26 28
Ashley Barnes 12 2 Forward Burnley 32 1989-10-30 27 37
Richarlison de Andrade 13 1 Forward Everton 25 1997-05-10 28 35
Gerard Deulofeu 10 5 Forward Watford 28 1994-03-13 29 30
Lucas Rodrigues Moura da Silva 10 0 Midfielder Tottenham Hotspur 30 1992-08-13 30 32
Karlan Ahearne-Grant 4 0 Forward Huddersfield Town 24 1997-12-19 31 13
Roberto Firmino 12 6 Forward Liverpool 31 1991-10-02 32 34
Gonzalo Higuain 5 0 Forward Chelsea 34 1987-12-10 33 14
Ivan Ricardo Neves Abreu Cavaleiro 3 1 Forward Wolverhampton Wanderers 29 1993-10-18 34 23
Pedro Rodriguez 8 2 Midfielder Chelsea 35 1987-07-28 35 31
Andriy Yarmolenko 2 0 Forward West Ham United 33 1989-10-23 36 9
Paul Pogba 13 9 Midfielder Manchester United 29 1993-03-15 37 35
Aboubakar Kamara 3 0 Forward Fulham 27 1995-03-07 38 13
Daniel William John Ings 7 3 Forward Southampton 30 1992-07-23 39 24
Rondon 11 7 Forward Newcastle United 33 1989-09-16 40 32
Marcus Rashford 10 6 Forward Manchester United 25 1997-10-31 41 33
Raúl Alonso Jiménez Rodríguez 13 7 Forward Wolverhampton Wanderers 31 1991-05-05 42 38
Gylfi Sigurdsson 13 6 Midfielder Everton 33 1989-09-08 43 38
Ayoze Perez 12 2 Forward Newcastle United 29 1993-07-29 44 37
Erik Lamela 4 2 Midfielder Tottenham Hotspur 30 1992-03-04 45 19
Nathaniel Mendez-Laing 4 1 Midfielder Cardiff City 30 1992-04-15 46 20
Ryan Guno Babel 5 3 Forward Fulham 35 1986-12-19 47 16
Daniel Sturridge 2 1 Forward Liverpool 33 1989-09-01 48 18
Joshua King 12 3 Forward AFC Bournemouth 30 1992-01-15 49 35
Chris Wood 10 2 Forward Burnley 30 1991-12-07 50 38
Shane Long 5 1 Forward Southampton 35 1987-01-22 51 26
Diogo José Teixeira da Silva 9 5 Midfielder Wolverhampton Wanderers 25 1996-12-04 52 33
Henrikh Mkhitaryan 6 4 Midfielder Arsenal 33 1989-01-21 53 25
André Schürrle 6 0 Midfielder Fulham 31 1990-11-06 54 24
Bobby Reid 5 2 Midfielder Cardiff City 29 1993-02-02 55 27
Ciaran Clark 3 0 Defender Newcastle United 33 1989-09-26 56 11
Troy Deeney 9 5 Forward Watford 34 1988-06-29 57 32
James Ward-Prowse 7 0 Midfielder Southampton 27 1994-11-01 58 26
Luka Milivojević 12 2 Midfielder Crystal Palace 31 1991-04-07 59 38
Florin Andone 3 0 Forward Brighton & Hove Albion 29 1993-04-11 60 23
José Luis Sanmartín Mato 2 0 Forward Newcastle United 32 1990-03-27 61 16
Aleksandar Mitrović 11 3 Forward Fulham 28 1994-09-16 62 37
Wilfried Zaha 10 5 Midfielder Crystal Palace 29 1992-11-10 63 34
Sam Vokes 3 0 Forward Burnley 33 1989-10-21 64 20
Dominic Calvert-Lewin 6 2 Forward Everton 25 1997-03-16 65 35
Matěj Vydra 1 1 Forward Burnley 30 1992-05-01 66 13
Philip Foden 1 0 Midfielder Manchester City 22 2000-05-28 67 13
David Brooks 7 5 Forward AFC Bournemouth 25 1997-07-08 68 30
Aaron Ramsey 4 6 Midfielder Arsenal 31 1990-12-26 69 28
Felipe Anderson Pereira Gomes 9 4 Midfielder West Ham United 29 1993-04-15 70 36
Phil Jagielka 1 0 Defender Everton 40 1982-08-17 71 7
Domingos Quina 1 0 Midfielder Watford 22 1999-11-18 72 8
Mesut Özil 5 2 Midfielder Arsenal 34 1988-10-15 73 24
Cenk Tosun 3 3 Forward Everton 31 1991-06-07 74 25
Lys Mousset 1 0 Forward AFC Bournemouth 26 1996-02-08 75 24
Christian Eriksen 8 12 Midfielder Tottenham Hotspur 30 1992-02-14 76 35
Michail Antonio 6 4 Midfielder West Ham United 32 1990-03-28 77 33
İlkay Gündoğan 6 3 Midfielder Manchester City 32 1990-10-24 78 31
Kadeem Harris 1 0 Midfielder Cardiff City 29 1993-06-08 79 13
Youri Tielemans 3 4 Midfielder Leicester City 25 1997-05-07 80 13
James Milner 5 4 Midfielder Liverpool 36 1986-01-04 81 31
Dele Alli 5 3 Midfielder Tottenham Hotspur 26 1996-04-11 82 25
James Maddison 7 7 Midfielder Leicester City 25 1996-11-23 83 36
Ross Barkley 3 5 Midfielder Chelsea 28 1993-12-05 84 27
Bernardo Silva 7 7 Midfielder Manchester City 28 1994-08-10 85 36
Olivier Giroud 2 4 Forward Chelsea 36 1986-09-30 86 27
Jesse Lingard 4 2 Midfielder Manchester United 29 1992-12-15 87 27
David Silva 6 8 Midfielder Manchester City 36 1986-01-08 88 33
Jeffrey Schlupp 4 1 Defender Crystal Palace 29 1992-12-23 89 30
Theo Walcott 5 2 Forward Everton 33 1989-03-16 90 37
Scott McTominay 2 0 Midfielder Manchester United 25 1996-12-08 91 16
Juan Mata 3 2 Midfielder Manchester United 34 1988-04-28 92 22
Laurent Koscielny 3 0 Defender Arsenal 37 1985-09-10 93 17
Danny Ward 1 0 Forward Cardiff City 31 1990-12-09 94 14
Ryan Fraser 7 14 Midfielder AFC Bournemouth 28 1994-02-24 95 38
Mark Noble 5 5 Midfielder West Ham United 35 1987-05-08 96 31
Roberto Maximiliano Pereyra 6 1 Forward Watford 31 1991-01-07 97 33
Stuart Armstrong 3 2 Midfielder Southampton 30 1992-03-30 98 29
Tom Cleverley 1 0 Midfielder Watford 33 1989-08-12 99 13
Manolo Gabbiadini 1 0 Forward Southampton 30 1991-11-26 100 12
Floyd Ayité 1 0 Midfielder Fulham 33 1988-12-15 101 16
Andros Townsend 6 4 Midfielder Crystal Palace 31 1991-07-16 102 38
Demarai Gray 4 1 Midfielder Leicester City 26 1996-06-28 103 34
Junior Stanislas 2 3 Midfielder AFC Bournemouth 32 1989-11-26 104 23
Charlie Austin 2 2 Forward Southampton 33 1989-07-05 105 25
Victor Wanyama 1 0 Midfielder Tottenham Hotspur 31 1991-06-25 106 13
Eric Dier 3 0 Midfielder Tottenham Hotspur 28 1994-01-15 107 20
Callum Paterson 4 1 Defender Cardiff City 28 1994-10-13 108 27
Kevin De Bruyne 2 2 Midfielder Manchester City 31 1991-06-28 109 19
Fabian Schär 4 1 Defender Newcastle United 30 1991-12-20 110 24
Víctor Camarasa 5 4 Midfielder Cardiff City 28 1994-05-28 111 32
Dwight McNeil 3 5 Forward Burnley 22 1999-11-22 112 21
Yoshinori Muto 1 0 Forward Newcastle United 30 1992-07-15 113 17
Joel Ward 1 0 Defender Crystal Palace 32 1989-10-29 114 7
Romain Saïss 2 0 Midfielder Wolverhampton Wanderers 32 1990-03-26 115 19
Nathan Redmond 6 4 Midfielder Southampton 28 1994-03-06 116 38
Andreas Pereira 1 1 Midfielder Manchester United 26 1996-01-01 117 15
Souleymane Bamba 4 1 Defender Cardiff City 37 1985-01-13 118 28
Josh Murphy 3 2 Forward Cardiff City 27 1995-02-24 119 29
Jürgen Locadia 2 0 Forward Brighton & Hove Albion 28 1993-11-07 120 26
Leon Balogun 1 0 Defender Brighton & Hove Albion 34 1988-06-28 121 8
Johann Berg Guðmunds­son 3 6 Midfielder Burnley 32 1990-10-27 122 29
Shane Duffy 5 1 Defender Brighton & Hove Albion 30 1992-01-01 123 35
Abdoulaye Doucouré 5 6 Midfielder Watford 29 1993-01-01 124 35
Wes Morgan 3 0 Defender Leicester City 38 1984-01-21 125 22
Pascal Groß 3 3 Midfielder Brighton & Hove Albion 31 1991-06-15 126 25
Granit Xhaka 4 2 Midfielder Arsenal 30 1992-09-27 127 29
Alex Iwobi 3 6 Forward Arsenal 26 1996-05-03 128 35
Mathias Jattah-Njie Jørgensen 3 1 Defender Huddersfield Town 32 1990-04-23 129 24
Manuel Lanzini 1 1 Midfielder West Ham United 29 1993-02-15 130 10
Jeff Hendrick 3 0 Midfielder Burnley 30 1992-01-31 131 32
Willian 3 6 Forward Chelsea 34 1988-08-09 132 32
Fernando Llorente Torres 1 4 Forward Tottenham Hotspur 37 1985-02-26 133 20
Ander Herrera 2 3 Midfielder Manchester United 33 1989-08-14 134 22
Sean Longstaff 1 0 Midfielder Newcastle United 25 1997-10-30 135 9
Pierre-Emile Højbjerg 4 3 Midfielder Southampton 27 1995-08-05 136 31
David Junior Hoilett 3 1 Forward Cardiff City 32 1990-06-05 137 32
Naby Deco Keïta 2 1 Midfielder Liverpool 27 1995-02-10 138 25
Jon Gorenc Stankovič 1 0 Defender Huddersfield Town 26 1996-01-14 139 11
Rachid Ghezzal 1 0 Forward Leicester City 30 1992-05-09 140 19
N’Golo Kanté 4 4 Midfielder Chelsea 31 1991-03-29 141 36
Kenneth Dahrup Zohorè 1 1 Forward Cardiff City 28 1994-01-31 142 19
Ken Sema 1 2 Midfielder Watford 29 1993-09-30 143 17
Aaron Mooy 3 1 Midfielder Huddersfield Town 32 1990-09-15 144 29
Rúben Diogo Da Silva Neves 4 3 Midfielder Wolverhampton Wanderers 25 1997-03-13 145 35
Leander Dendoncker 2 0 Midfielder Wolverhampton Wanderers 27 1995-04-15 146 19
Lucas Digne 4 4 Defender Everton 29 1993-07-20 147 35
Willy Boly 4 0 Defender Wolverhampton Wanderers 31 1991-02-03 148 36
Christian Benteke 1 1 Forward Crystal Palace 31 1990-12-03 149 16
Nathan Aké 4 0 Defender AFC Bournemouth 27 1995-02-18 150 38
Danilo 1 0 Defender Manchester City 31 1991-07-15 151 11
Virgil van Dijk 4 2 Defender Liverpool 31 1991-07-08 152 38
José Holebas 3 6 Defender Watford 38 1984-06-27 153 28
Jordon Ibe 1 1 Midfielder AFC Bournemouth 26 1995-12-08 154 19
Matt Doherty 4 5 Defender Wolverhampton Wanderers 30 1992-01-16 155 38
Marc Albrighton 2 2 Midfielder Leicester City 32 1989-11-18 156 27
Juan Marcos Foyth 1 0 Defender Tottenham Hotspur 24 1998-01-12 157 12
Dan Gosling 2 1 Midfielder AFC Bournemouth 32 1990-02-01 158 25
Anthony Knockaert 2 6 Midfielder Brighton & Hove Albion 30 1991-11-20 159 30
Adama Traoré Diarra 1 1 Midfielder Wolverhampton Wanderers 26 1996-01-25 160 29
Yerry Fernando Mina González 1 0 Defender Everton 28 1994-09-23 161 13
Yann Valery 2 1 Defender Southampton 23 1999-02-22 162 23
Beram Kayal 1 1 Midfielder Brighton & Hove Albion 34 1988-05-02 163 18
Georginio Wijnaldum 3 0 Midfielder Liverpool 31 1990-11-11 164 35
Harry Maguire 3 0 Defender Leicester City 29 1993-03-05 165 31
Alexis Sanchez 1 3 Forward Manchester United 33 1988-12-19 166 20
Jonjo Shelvey 1 1 Midfielder Newcastle United 30 1992-02-27 167 16
Steve Mounié 2 3 Forward Huddersfield Town 28 1994-09-29 168 31
Kelechi Iheanacho 1 3 Forward Leicester City 26 1996-10-03 169 30
James Tarkowski 3 1 Defender Burnley 29 1992-11-19 170 35
Alex Pritchard 2 0 Midfielder Huddersfield Town 29 1993-05-03 171 30
Isaac Mbenza 1 1 Forward Huddersfield Town 26 1996-03-08 172 22
Dejan Lovren 1 0 Defender Liverpool 33 1989-07-05 173 13
Ainsley Maitland-Niles 1 1 Midfielder Arsenal 25 1997-08-29 174 16
Harvey Lewis Barnes 1 2 Midfielder Leicester City 24 1997-12-09 175 16
Aymeric Laporte 3 3 Defender Manchester City 28 1994-05-27 176 35
Craig Cathcart 3 0 Defender Watford 33 1989-02-06 177 36
Frederico Rodrigues Santos 1 1 Midfielder Manchester United 29 1993-03-05 178 17
James McArthur 3 6 Midfielder Crystal Palace 35 1987-10-07 179 38
Luciano Vietto 1 4 Forward Fulham 28 1993-12-05 180 20
Isaac Ajayi Success 1 1 Forward Watford 26 1996-01-07 181 30
Ryan Sessegnon 2 6 Defender Fulham 22 2000-05-18 182 35
Matt Targett 1 3 Defender Southampton 27 1995-09-18 183 16
Patrick van Aanholt 3 2 Defender Crystal Palace 32 1990-08-29 184 36
Philip Billing 2 0 Midfielder Huddersfield Town 26 1996-06-11 185 27
David Luiz 3 2 Defender Chelsea 35 1987-04-22 186 36
Jordan Ayew 1 2 Forward Crystal Palace 31 1991-09-11 187 20
Robert Snodgrass 2 5 Midfielder West Ham United 35 1987-09-07 188 33
Ryan Fredericks 1 0 Midfielder West Ham United 30 1992-10-10 189 15
Lucas Torreira 2 2 Midfielder Arsenal 26 1996-02-11 190 34
Marcos Alonso 2 4 Defender Chelsea 31 1990-12-28 191 31
Kurt Zouma 2 2 Defender Everton 28 1994-10-27 192 32
Robert Kenedy Nunes do Nascimento 1 1 Midfielder Newcastle United 26 1996-02-08 193 25
Vincent Kompany 1 0 Defender Manchester City 36 1986-04-10 194 17
Ashley Young 2 2 Midfielder Manchester United 37 1985-07-09 195 30
Aaron Lennon 1 1 Midfielder Burnley 35 1987-04-16 196 16
Séamus Coleman 2 2 Defender Everton 34 1988-10-11 197 29
Calum Chambers 2 0 Defender Fulham 27 1995-01-20 198 31
Will Hughes 2 4 Midfielder Watford 27 1995-04-17 199 32
Hélder Wander Sousa Azevedo Costa 1 2 Midfielder Wolverhampton Wanderers 28 1994-01-12 200 25
Shkodran Mustafi 2 0 Defender Arsenal 30 1992-04-17 201 31
Jefferson Lerma 2 0 Midfielder AFC Bournemouth 28 1994-10-25 202 30
Lewis Dunk 2 1 Defender Brighton & Hove Albion 30 1991-11-21 203 36
Cedric Soares 1 2 Defender Southampton 31 1991-08-31 204 18
Juninho Bacuna 1 0 Midfielder Huddersfield Town 25 1997-08-07 205 21
Christian Atsu Twasam 1 0 Midfielder Newcastle United 30 1992-01-10 206 28
Harry Winks 1 0 Midfielder Tottenham Hotspur 26 1996-02-02 207 26
Charlie Daniels 1 0 Defender AFC Bournemouth 36 1986-09-07 208 21
Max Meyer 1 2 Midfielder Crystal Palace 27 1995-09-18 209 29
Declan Rice 2 0 Midfielder West Ham United 23 1999-01-14 210 34
Mario Lemina 1 1 Midfielder Southampton 29 1993-09-01 211 21
Ashley Westwood 2 7 Midfielder Burnley 32 1990-04-01 212 34
Jorginho 2 0 Midfielder Chelsea 30 1991-12-20 213 37
Ricardo Domingos Barbosa Pereira 2 6 Defender Leicester City 29 1993-10-06 214 35
Joel Matip 1 0 Defender Liverpool 31 1991-08-08 215 22
Matt Ritchie 2 8 Midfielder Newcastle United 33 1989-09-10 216 36
Jordan Henderson 1 3 Midfielder Liverpool 32 1990-06-17 217 32
Onyinye Wilfred Ndidi 2 0 Midfielder Leicester City 25 1996-12-16 218 38
Isaac Hayden 1 4 Midfielder Newcastle United 27 1995-03-22 219 25
André Filipe Tavares Gomes 1 1 Midfielder Everton 29 1993-07-30 220 27
Davinson Sánchez Mina 1 1 Defender Tottenham Hotspur 26 1996-06-12 221 23
Nacho Monreal 1 3 Defender Arsenal 36 1986-02-26 222 22
Jack Stephens 1 0 Defender Southampton 28 1994-01-27 223 24
Jonny Evans 1 0 Defender Leicester City 34 1988-01-03 224 24
Jan Vertonghen 1 0 Defender Tottenham Hotspur 35 1987-04-24 225 22
Angelo Ogbonna 1 1 Defender West Ham United 34 1988-05-23 226 24
Adam Smith 1 1 Defender AFC Bournemouth 31 1991-04-29 227 25
Fernando Luiz Rosa 1 3 Midfielder Manchester City 37 1985-05-04 228 29
Fabinho 1 2 Midfielder Liverpool 29 1993-10-23 229 28
Kieran Trippier 1 3 Defender Tottenham Hotspur 32 1990-09-19 230 27
Fabián Cornelio Balbuena González 1 0 Defender West Ham United 31 1991-08-23 231 23
Aron Einar Gunnarsson 1 1 Midfielder Cardiff City 33 1989-04-22 232 28
Trent Alexander-Arnold 1 12 Defender Liverpool 24 1998-10-07 233 29
Sokratis Papastathopoulos 1 2 Defender Arsenal 34 1988-06-09 234 25
James Tomkins 1 1 Defender Crystal Palace 33 1989-03-29 235 29
Jean Michau00ebl Seri 1 2 Midfielder Fulham 31 1991-07-19 236 32
DeAndre Yedlin 1 2 Defender Newcastle United 29 1993-07-09 237 29
Tom Cairney 1 1 Midfielder Fulham 31 1991-01-20 238 31
Nemanja Matić 1 0 Midfielder Manchester United 34 1988-08-01 239 28
Francisco Femenía Far 1 1 Midfielder Watford 31 1991-02-02 240 29
Davy Pröpper 1 1 Midfielder Brighton & Hove Albion 31 1991-09-02 241 30
Solomon March 1 5 Midfielder Brighton & Hove Albion 28 1994-07-20 242 35
Bernard Anício Caldeira Duarte 1 3 Midfielder Everton 30 1992-09-08 243 34
Oriol Romeu 1 0 Midfielder Southampton 31 1991-09-24 244 31
Ryan Bertrand 1 0 Defender Southampton 33 1989-08-05 245 24
Chris Smalling 1 0 Defender Manchester United 32 1989-11-22 246 24
Dale Stephens 1 1 Midfielder Brighton & Hove Albion 33 1989-06-12 247 30
Issa Diop 1 0 Defender West Ham United 25 1997-01-09 248 33
Jack Cork 1 2 Midfielder Burnley 33 1989-06-25 249 37
Kyle Walker 1 1 Defender Manchester City 32 1990-05-28 250 33
Michael Keane 1 2 Defender Everton 29 1993-01-11 251 33
Christopher Schindler 1 0 Defender Huddersfield Town 32 1990-04-29 252 37
Etienne Capoue 1 3 Midfielder Watford 34 1988-07-11 253 33
Steve Cook 1 1 Defender AFC Bournemouth 31 1991-04-19 254 31
Sean Morrison 1 3 Defender Cardiff City 31 1991-01-08 255 34
Ryan Bennett 1 0 Defender Wolverhampton Wanderers 32 1990-03-06 256 34
Jonny 1 1 Defender Wolverhampton Wanderers 28 1994-03-03 257 33
João Moutinho 1 8 Midfielder Wolverhampton Wanderers 36 1986-09-08 258 38
Antonio Rüdiger 1 0 Defender Chelsea 29 1993-03-03 259 33
Cesar Azpilicueta 1 5 Defender Chelsea 33 1989-08-28 260 38
Terence Kongolo 1 1 Defender Huddersfield Town 28 1994-02-14 261 32
Luke Shaw 1 4 Defender Manchester United 27 1995-07-12 262 29
Victor Nilsson Lindelöf 1 1 Defender Manchester United 28 1994-07-17 263 30
Steven Defour 0 0 Midfielder Burnley 34 1988-04-15 264 6
Tim Ream 0 0 Defender Fulham 35 1987-10-05 265 26
Jose Izquierdo 0 1 Forward Brighton & Hove Albion 30 1992-07-07 266 15
Caglar Söyüncü 0 0 Defender Leicester City 26 1996-05-23 267 6
Robbie Brady 0 1 Midfielder Burnley 30 1992-01-14 268 16
Danny Simpson 0 0 Defender Leicester City 35 1987-01-04 269 6
Andy Carroll 0 0 Forward West Ham United 33 1989-01-06 270 12
Nampalys Mendy 0 0 Midfielder Leicester City 30 1992-06-23 271 31
Jack Simpson 0 0 Defender AFC Bournemouth 25 1996-12-18 272 6
Nicolas Otamendi 0 0 Defender Manchester City 34 1988-02-12 273 18
Emerson Palmieri dos Santos 0 0 Defender Chelsea 28 1994-08-03 274 10
Hamza Choudhury 0 0 Midfielder Leicester City 25 1997-10-01 275 9
Scott Dann 0 1 Defender Crystal Palace 35 1987-02-14 276 10
Callum Hudson-Odoi 0 1 Midfielder Chelsea 21 2000-11-07 277 10
Florian Lejeune 0 0 Defender Newcastle United 31 1991-05-20 278 12
Chris Mepham 0 1 Defender AFC Bournemouth 24 1997-11-05 279 13
Dominic Solanke 0 1 Forward AFC Bournemouth 25 1997-09-14 280 10
Leandro Bacuna 0 0 Midfielder Cardiff City 31 1991-08-21 281 11
Miguel Ángel Almirón Rejala 0 0 Midfielder Newcastle United 28 1994-02-10 282 10
José Diogo Dalot Teixeira 0 2 Defender Manchester United 23 1999-03-18 283 16
Oleksandr Zinchenko 0 3 Midfielder Manchester City 25 1996-12-15 284 14
Sead Kolašinac 0 5 Defender Arsenal 29 1993-06-20 285 24
Denis Odoi 0 1 Defender Fulham 34 1988-05-27 286 31
Danny Rose 0 3 Defender Tottenham Hotspur 32 1990-07-02 287 26
André-Frank Zambo Anguissa 0 0 Midfielder Fulham 26 1995-11-16 288 22
Jonjoe Kenny 0 1 Defender Everton 25 1997-03-15 289 10
Aaron Cresswell 0 1 Defender West Ham United 32 1989-12-15 290 20
Mateo Kovačić 0 2 Midfielder Chelsea 28 1994-05-06 291 32
Ademola Lookman 0 2 Forward Everton 25 1997-10-20 292 21
Kevin Long 0 1 Defender Burnley 32 1990-08-18 293 6
Martín Montoya 0 1 Defender Brighton & Hove Albion 31 1991-04-14 294 25
Fabian Delph 0 1 Midfielder Manchester City 32 1989-11-21 295 11
Marcus Bettinelli 0 0 Goalkeeper Fulham 30 1992-05-24 296 7
Federico Fernández 0 1 Defender Newcastle United 33 1989-02-21 297 19
Grady Diangana 0 1 Midfielder West Ham United 24 1998-04-19 298 17
Phil Jones 0 1 Defender Manchester United 30 1992-02-21 299 18
Antonio Valencia 0 0 Defender Manchester United 37 1985-08-04 300 6
Jacob Murphy 0 1 Midfielder Newcastle United 27 1995-02-24 301 9
Jason Puncheon 0 0 Midfielder Huddersfield Town 36 1986-06-26 302 11
Elias Kachunga 0 0 Forward Huddersfield Town 30 1992-04-22 303 20
Harry Arter 0 1 Midfielder Cardiff City 32 1989-12-28 304 25
Erik Durm 0 1 Defender Huddersfield Town 30 1992-05-12 305 28
Diego Rico 0 0 Defender AFC Bournemouth 29 1993-02-23 306 12
Alfie Mawson 0 0 Defender Fulham 28 1994-01-19 307 15
Maya Yoshida 0 1 Defender Southampton 34 1988-08-24 308 17
John Stones 0 0 Defender Manchester City 28 1994-05-28 309 24
David de Gea 0 0 Goalkeeper Manchester United 31 1990-11-07 310 38
Benjamin Mendy 0 5 Defender Manchester City 28 1994-07-17 311 10
Aaron Wan-Bissaka 0 3 Midfielder Crystal Palace 24 1997-11-26 312 35
Greg Cunningham 0 0 Defender Cardiff City 31 1991-01-31 313 7
Maxime Le Marchand 0 1 Defender Fulham 33 1989-10-11 314 26
Cyrus Christie 0 1 Defender Fulham 30 1992-09-30 315 28
Joe Bryan 0 1 Defender Fulham 29 1993-09-17 316 28
Kevin McDonald 0 0 Midfielder Fulham 33 1988-11-04 317 15
Stefan Marius Johansen 0 0 Midfielder Fulham 31 1991-01-08 318 12
Timothy Fosu-Mensah 0 0 Defender Fulham 24 1998-01-02 319 12
Sergio Rico 0 0 Goalkeeper Fulham 29 1993-09-01 320 29
Wayne Hennessey 0 0 Goalkeeper Crystal Palace 35 1987-01-24 321 18
Mamadou Sakho 0 0 Defender Crystal Palace 32 1990-02-13 322 27
Cheikhou Kouyaté 0 2 Midfielder Crystal Palace 32 1989-12-21 323 31
Joe Bennett 0 1 Defender Cardiff City 32 1990-03-28 324 30
Vicente Guaita 0 0 Goalkeeper Crystal Palace 35 1987-01-10 325 20
Martin Kelly 0 0 Defender Crystal Palace 32 1990-04-27 326 13
Ben Hamer 0 0 Goalkeeper Huddersfield Town 34 1987-11-20 327 7
Chris Löwe 0 2 Defender Huddersfield Town 33 1989-04-16 328 29
Florent Hadergjonaj 0 0 Defender Huddersfield Town 28 1994-07-31 329 24
Jonathan Hogg 0 1 Midfielder Huddersfield Town 33 1988-12-06 330 29
Laurent Depoitre 0 1 Forward Huddersfield Town 33 1988-12-07 331 23
Adama Diakhaby 0 0 Forward Huddersfield Town 26 1996-07-05 332 12
Jonas Lössl 0 1 Goalkeeper Huddersfield Town 33 1989-02-01 333 31
Tom Smith 0 0 Defender Huddersfield Town 30 1992-04-14 334 15
Rajiv van La Parra 0 0 Midfielder Huddersfield Town 31 1991-06-04 335 5
Joe Ralls 0 0 Midfielder Cardiff City 29 1993-10-13 336 28
Bruno Écuélé Manga 0 1 Defender Cardiff City 34 1988-07-16 337 38
Andreas Christensen 0 0 Defender Chelsea 26 1996-04-10 338 8
Hugo Lloris 0 0 Goalkeeper Tottenham Hotspur 35 1986-12-26 339 33
Eric Bertrand Bailly 0 0 Defender Manchester United 28 1994-04-12 340 12
Marouane Fellaini 0 1 Midfielder Manchester United 34 1987-11-22 341 14
Kasper Schmeichel 0 0 Goalkeeper Leicester City 35 1986-11-05 342 38
Daniel Amartey 0 0 Midfielder Leicester City 27 1994-12-21 343 9
Ben Chilwell 0 4 Defender Leicester City 25 1996-12-21 344 36
Martin Dúbravka 0 0 Goalkeeper Newcastle United 33 1989-01-15 345 38
Jamal Lascelles 0 1 Defender Newcastle United 28 1993-11-11 346 32
Paul Dummett 0 0 Defender Newcastle United 31 1991-09-26 347 26
Mohamed Diamé 0 0 Midfielder Newcastle United 35 1987-06-14 348 29
Sung-Yeung Ki 0 1 Midfielder Newcastle United 33 1989-01-24 349 18
Javier Manquillo Gaitán 0 3 Defender Newcastle United 28 1994-05-05 350 18
Serge Aurier 0 2 Defender Tottenham Hotspur 29 1992-12-24 351 8
Lee Peltier 0 0 Defender Cardiff City 35 1986-12-11 352 20
Ben Davies 0 0 Defender Tottenham Hotspur 29 1993-04-24 353 27
Moussa Sissoko 0 3 Midfielder Tottenham Hotspur 33 1989-08-16 354 29
Moussa Dembele 0 0 Midfielder Tottenham Hotspur 35 1987-07-16 355 10
Toby Alderweireld 0 0 Defender Tottenham Hotspur 33 1989-03-02 356 34
Kyle Walker-Peters 0 3 Defender Tottenham Hotspur 25 1997-04-13 357 6
Asmir Begović 0 0 Goalkeeper AFC Bournemouth 35 1987-06-20 358 24
Andrew Surman 0 0 Midfielder AFC Bournemouth 36 1986-08-20 359 18
Simon Francis 0 2 Defender AFC Bournemouth 37 1985-02-16 360 17
Artur Boruc 0 0 Goalkeeper AFC Bournemouth 42 1980-02-20 361 12
Lewis Cook 0 0 Midfielder AFC Bournemouth 25 1997-02-03 362 13
Neil Leonard Dula Etheridge 0 0 Goalkeeper Cardiff City 32 1990-02-07 363 38
Kepa Arrizabalaga 0 0 Goalkeeper Chelsea 28 1994-10-03 364 36
Ben Foster 0 0 Goalkeeper Watford 39 1983-04-03 365 38
Ederson 0 1 Goalkeeper Manchester City 29 1993-08-17 366 38
Joe Hart 0 0 Goalkeeper Burnley 35 1987-04-19 367 19
Arthur Masuaku 0 1 Defender West Ham United 28 1993-11-07 368 23
Jack Wilshere 0 1 Midfielder West Ham United 30 1992-01-01 369 8
Pablo Zabaleta 0 1 Defender West Ham United 37 1985-01-16 370 26
Pedro Obiang 0 1 Midfielder West Ham United 30 1992-03-27 371 24
Alex McCarthy 0 0 Goalkeeper Southampton 32 1989-12-03 372 25
Jannik Vestergaard 0 0 Defender Southampton 30 1992-08-03 373 23
Wesley Hoedt 0 0 Defender Southampton 28 1994-03-06 374 13
Mohamed Elyounoussi 0 0 Midfielder Southampton 28 1994-08-04 375 16
Angus Gunn 0 0 Goalkeeper Southampton 26 1996-01-22 376 12
Jan Bednarek 0 1 Defender Southampton 26 1996-04-12 377 25
Matthew Lowton 0 0 Defender Burnley 33 1989-06-09 378 21
Adam David Lallana 0 0 Midfielder Liverpool 34 1988-05-10 379 13
Ben Mee 0 2 Defender Burnley 33 1989-09-21 380 38
Charlie Taylor 0 1 Defender Burnley 29 1993-09-18 381 38
Tom Heaton 0 0 Goalkeeper Burnley 36 1986-04-15 382 19
Phil Bardsley 0 0 Defender Burnley 37 1985-06-28 383 19
Petr Čech 0 0 Goalkeeper Arsenal 40 1982-05-20 384 7
Hector Bellerin 0 5 Defender Arsenal 27 1995-03-19 385 19
Mattéo Guendouzi Olié 0 0 Midfielder Arsenal 23 1999-04-14 386 33
Stephan Lichtsteiner 0 0 Defender Arsenal 38 1984-01-16 387 14
Mohamed Elneny 0 0 Midfielder Arsenal 30 1992-07-11 388 8
Rob Holding 0 0 Defender Arsenal 27 1995-09-20 389 10
Bernd Leno 0 0 Goalkeeper Arsenal 30 1992-03-04 390 32
Łukasz Fabiański 0 0 Goalkeeper West Ham United 37 1985-04-18 391 38
Nathaniel Clyne 0 1 Defender AFC Bournemouth 31 1991-04-05 392 18
Christian Kabasele 0 0 Defender Watford 31 1991-02-24 393 21
Conor Coady 0 0 Midfielder Wolverhampton Wanderers 29 1993-02-25 394 38
Daryl Janmaat 0 2 Defender Watford 33 1989-07-22 395 18
Adrian Mariappa 0 0 Defender Watford 36 1986-10-03 396 26
Adam Masina 0 1 Defender Watford 28 1994-01-02 397 14
Mathew Ryan 0 0 Goalkeeper Brighton & Hove Albion 30 1992-04-08 398 34
Bruno Saltor Grau 0 1 Defender Brighton & Hove Albion 42 1980-10-01 399 14
Bernardo 0 1 Defender Brighton & Hove Albion 27 1995-05-14 400 22
Gaëtan Bong Songo 0 0 Defender Brighton & Hove Albion 34 1988-04-25 401 22
Yves Bissouma 0 0 Midfielder Brighton & Hove Albion 26 1996-08-30 402 28
Alireza Jahanbakhsh 0 0 Forward Brighton & Hove Albion 29 1993-08-11 403 19
David Button 0 0 Goalkeeper Brighton & Hove Albion 33 1989-02-27 404 4
Rui Pedro dos Santos Patrício 0 0 Goalkeeper Wolverhampton Wanderers 34 1988-02-15 405 37
Rúben Gonçalo Silva Nascimento Vinagre 0 0 Defender Wolverhampton Wanderers 23 1999-04-09 406 17
Joe Gomez 0 0 Defender Liverpool 25 1997-05-23 407 16
Morgan Gibbs-White 0 1 Midfielder Wolverhampton Wanderers 22 2000-01-27 408 26
Jordan Pickford 0 0 Goalkeeper Everton 28 1994-03-07 409 38
Leighton Baines 0 0 Defender Everton 37 1984-12-11 410 6
Matteo Darmian 0 0 Defender Manchester United 32 1989-12-02 411 6
Morgan Schneiderlin 0 1 Midfielder Everton 32 1989-11-08 412 14
Idrissa Gana Gueye 0 2 Midfielder Everton 33 1989-09-26 413 33
Mason Holgate 0 0 Defender Everton 26 1996-10-22 414 5
Oumar Niasse 0 0 Forward Cardiff City 32 1990-04-18 415 18
Tom Davies 0 0 Midfielder Everton 24 1998-06-30 416 16
Alisson Becker 0 0 Goalkeeper Liverpool 30 1992-10-02 417 38
Andrew Robertson 0 11 Defender Liverpool 28 1994-03-11 418 36
Håvard Nordtveit 0 1 Midfielder Fulham 32 1990-06-21 419 5

Best Midfielder

A midfielders job is to make sure that they are an open to passing, assisting people in getting their goals, and making sure the ball stays on the attack.

Mid <- filter(df, rank_in_league_top_midfielders != -1) %>% 
  select(c('full_name','assists_overall','position','current_club','age','birthday_gmt', 'rank_in_league_top_midfielders', 'appearances_overall' )) 

MidClean <- Mid[order(Mid$rank_in_league_top_midfielders),]

kable(MidClean, format = "html" , caption = "Top league Midfielders",align = "cccccccccccccccc") %>% kable_styling()
Top league Midfielders
full_name assists_overall position current_club age birthday_gmt rank_in_league_top_midfielders appearances_overall
Kyle Walker-Peters 3 Defender Tottenham Hotspur 25 1997-04-13 1 6
Fernando Llorente Torres 4 Forward Tottenham Hotspur 37 1985-02-26 2 20
Benjamin Mendy 5 Defender Manchester City 28 1994-07-17 3 10
Leroy Sané 10 Midfielder Manchester City 26 1996-01-11 4 31
Eden Hazard 15 Midfielder Chelsea 31 1991-01-07 5 37
Trent Alexander-Arnold 12 Defender Liverpool 24 1998-10-07 6 29
Olivier Giroud 4 Forward Chelsea 36 1986-09-30 7 27
Aaron Ramsey 6 Midfielder Arsenal 31 1990-12-26 8 28
Ryan Fraser 14 Midfielder AFC Bournemouth 28 1994-02-24 9 38
Christian Eriksen 12 Midfielder Tottenham Hotspur 30 1992-02-14 10 35
Luciano Vietto 4 Forward Fulham 28 1993-12-05 11 20
Ross Barkley 5 Midfielder Chelsea 28 1993-12-05 12 27
Youri Tielemans 4 Midfielder Leicester City 25 1997-05-07 13 13
Raheem Sterling 10 Forward Manchester City 27 1994-12-08 14 34
Serge Aurier 2 Defender Tottenham Hotspur 29 1992-12-24 15 8
Callum Wilson 9 Forward AFC Bournemouth 30 1992-02-27 16 30
Alexis Sanchez 3 Forward Manchester United 33 1988-12-19 17 20
Johann Berg Guðmunds­son 6 Midfielder Burnley 32 1990-10-27 18 29
Andrew Robertson 11 Defender Liverpool 28 1994-03-11 19 36
Ademola Lookman 2 Forward Everton 25 1997-10-20 20 21
Jacob Murphy 1 Midfielder Newcastle United 27 1995-02-24 21 9
David Silva 8 Midfielder Manchester City 36 1986-01-08 22 33
Matěj Vydra 1 Forward Burnley 30 1992-05-01 23 13
Kelechi Iheanacho 3 Forward Leicester City 26 1996-10-03 24 30
Alexandre Lacazette 8 Forward Arsenal 31 1991-05-28 25 35
Hector Bellerin 5 Defender Arsenal 27 1995-03-19 26 19
Anthony Knockaert 6 Midfielder Brighton & Hove Albion 30 1991-11-20 27 30
Sergio Aguero 8 Forward Manchester City 34 1988-06-02 28 33
Dwight McNeil 5 Forward Burnley 22 1999-11-22 29 21
Paul Pogba 9 Midfielder Manchester United 29 1993-03-15 30 35
Alex Iwobi 6 Forward Arsenal 26 1996-05-03 31 35
Riyad Mahrez 4 Midfielder Manchester City 31 1991-02-21 32 27
Gabriel Jesus 3 Forward Manchester City 25 1997-04-03 33 29
Heung-Min Son 6 Forward Tottenham Hotspur 30 1992-07-08 34 31
Junior Stanislas 3 Midfielder AFC Bournemouth 32 1989-11-26 35 23
Willian 6 Forward Chelsea 34 1988-08-09 36 32
Cenk Tosun 3 Forward Everton 31 1991-06-07 37 25
Dominic Solanke 1 Forward AFC Bournemouth 25 1997-09-14 38 10
Xherdan Shaqiri 3 Midfielder Liverpool 31 1991-10-10 39 24
Javier Manquillo Gaitán 3 Defender Newcastle United 28 1994-05-05 40 18
Håvard Nordtveit 1 Midfielder Fulham 32 1990-06-21 41 5
Divock Origi 1 Forward Liverpool 27 1995-04-18 42 12
Rondon 7 Forward Newcastle United 33 1989-09-16 43 32
João Moutinho 8 Midfielder Wolverhampton Wanderers 36 1986-09-08 44 38
Sead Kolašinac 5 Defender Arsenal 29 1993-06-20 45 24
Matt Ritchie 8 Midfielder Newcastle United 33 1989-09-10 46 36
Ken Sema 2 Midfielder Watford 29 1993-09-30 47 17
Jack Wilshere 1 Midfielder West Ham United 30 1992-01-01 48 8
José Holebas 6 Defender Watford 38 1984-06-27 49 28
Oleksandr Zinchenko 3 Midfielder Manchester City 25 1996-12-15 50 14
Matt Targett 3 Defender Southampton 27 1995-09-18 51 16
Marcus Rashford 6 Forward Manchester United 25 1997-10-31 52 33
Ryan Sessegnon 6 Defender Fulham 22 2000-05-18 53 35
Callum Hudson-Odoi 1 Midfielder Chelsea 21 2000-11-07 54 10
Ashley Westwood 7 Midfielder Burnley 32 1990-04-01 55 34
Henrikh Mkhitaryan 4 Midfielder Arsenal 33 1989-01-21 56 25
Mohamed Salah 8 Forward Liverpool 30 1992-06-15 57 38
Bernardo Silva 7 Midfielder Manchester City 28 1994-08-10 58 36
Gerard Deulofeu 5 Forward Watford 28 1994-03-13 59 30
James Maddison 7 Midfielder Leicester City 25 1996-11-23 60 36
Ryan Guno Babel 3 Forward Fulham 35 1986-12-19 61 16
Roberto Firmino 6 Forward Liverpool 31 1991-10-02 62 34
Raúl Alonso Jiménez Rodríguez 7 Forward Wolverhampton Wanderers 31 1991-05-05 63 38
Robert Snodgrass 5 Midfielder West Ham United 35 1987-09-07 64 33
James Milner 4 Midfielder Liverpool 36 1986-01-04 65 31
David Brooks 5 Forward AFC Bournemouth 25 1997-07-08 66 30
Isaac Hayden 4 Midfielder Newcastle United 27 1995-03-22 67 25
Ander Herrera 3 Midfielder Manchester United 33 1989-08-14 68 22
Erik Lamela 2 Midfielder Tottenham Hotspur 30 1992-03-04 69 19
Mark Noble 5 Midfielder West Ham United 35 1987-05-08 70 31
Diogo José Teixeira da Silva 5 Midfielder Wolverhampton Wanderers 25 1996-12-04 71 33
Kevin Long 1 Defender Burnley 32 1990-08-18 72 6
Charlie Austin 2 Forward Southampton 33 1989-07-05 73 25
James McArthur 6 Midfielder Crystal Palace 35 1987-10-07 74 38
Kevin De Bruyne 2 Midfielder Manchester City 31 1991-06-28 75 19
Marko Arnautović 4 Forward West Ham United 33 1989-04-19 76 28
José Diogo Dalot Teixeira 2 Defender Manchester United 23 1999-03-18 77 16
Harvey Lewis Barnes 2 Midfielder Leicester City 24 1997-12-09 78 16
Daniel Sturridge 1 Forward Liverpool 33 1989-09-01 79 18
Abdoulaye Doucouré 6 Midfielder Watford 29 1993-01-01 80 35
Troy Deeney 5 Forward Watford 34 1988-06-29 81 32
Solomon March 5 Midfielder Brighton & Hove Albion 28 1994-07-20 82 35
Ruben Loftus-Cheek 2 Midfielder Chelsea 26 1996-01-23 83 24
Ricardo Domingos Barbosa Pereira 6 Defender Leicester City 29 1993-10-06 84 35
Michail Antonio 4 Midfielder West Ham United 32 1990-03-28 85 33
Gylfi Sigurdsson 6 Midfielder Everton 33 1989-09-08 86 38
Daniel William John Ings 3 Forward Southampton 30 1992-07-23 87 24
Pierre-Emerick Aubameyang 5 Forward Arsenal 33 1989-06-18 88 36
Grady Diangana 1 Midfielder West Ham United 24 1998-04-19 89 17
Steve Mounié 3 Forward Huddersfield Town 28 1994-09-29 90 31
Will Hughes 4 Midfielder Watford 27 1995-04-17 91 32
Wilfried Zaha 5 Midfielder Crystal Palace 29 1992-11-10 92 34
Andreas Pereira 1 Midfielder Manchester United 26 1996-01-01 93 15
Harry Kane 4 Forward Tottenham Hotspur 29 1993-07-28 94 28
Danny Rose 3 Defender Tottenham Hotspur 32 1990-07-02 95 26
Jordan Ayew 2 Forward Crystal Palace 31 1991-09-11 96 20
Dele Alli 3 Midfielder Tottenham Hotspur 26 1996-04-11 97 25
Nacho Monreal 3 Defender Arsenal 36 1986-02-26 98 22
Simon Francis 2 Defender AFC Bournemouth 37 1985-02-16 99 17
Matt Doherty 5 Defender Wolverhampton Wanderers 30 1992-01-16 100 38
Scott Dann 1 Defender Crystal Palace 35 1987-02-14 101 10
Jordan Henderson 3 Midfielder Liverpool 32 1990-06-17 102 32
Juan Mata 2 Midfielder Manchester United 34 1988-04-28 103 22
Pascal Groß 3 Midfielder Brighton & Hove Albion 31 1991-06-15 104 25
Luke Shaw 4 Defender Manchester United 27 1995-07-12 105 29
Víctor Camarasa 4 Midfielder Cardiff City 28 1994-05-28 106 32
Morgan Gibbs-White 1 Midfielder Wolverhampton Wanderers 22 2000-01-27 107 26
Robbie Brady 1 Midfielder Burnley 30 1992-01-14 108 16
Andre Gray 2 Forward Watford 31 1991-06-26 109 29
Max Meyer 2 Midfielder Crystal Palace 27 1995-09-18 110 29
Manuel Lanzini 1 Midfielder West Ham United 29 1993-02-15 111 10
Marcos Alonso 4 Defender Chelsea 31 1990-12-28 112 31
Hélder Wander Sousa Azevedo Costa 2 Midfielder Wolverhampton Wanderers 28 1994-01-12 113 25
Stuart Armstrong 2 Midfielder Southampton 30 1992-03-30 114 29
Bobby Reid 2 Midfielder Cardiff City 29 1993-02-02 115 27
Cesar Azpilicueta 5 Defender Chelsea 33 1989-08-28 116 38
Bernard Anício Caldeira Duarte 3 Midfielder Everton 30 1992-09-08 117 34
Jamie Vardy 4 Forward Leicester City 35 1987-01-11 118 34
Ivan Ricardo Neves Abreu Cavaleiro 1 Forward Wolverhampton Wanderers 29 1993-10-18 119 23
İlkay Gündoğan 3 Midfielder Manchester City 32 1990-10-24 120 31
Daryl Janmaat 2 Defender Watford 33 1989-07-22 121 18
Kieran Trippier 3 Defender Tottenham Hotspur 32 1990-09-19 122 27
Fabian Delph 1 Midfielder Manchester City 32 1989-11-21 123 11
Cedric Soares 2 Defender Southampton 31 1991-08-31 124 18
Lucas Digne 4 Defender Everton 29 1993-07-20 125 35
N’Golo Kanté 4 Midfielder Chelsea 31 1991-03-29 126 36
Andros Townsend 4 Midfielder Crystal Palace 31 1991-07-16 127 38
Kenneth Dahrup Zohorè 1 Forward Cardiff City 28 1994-01-31 128 19
Marouane Fellaini 1 Midfielder Manchester United 34 1987-11-22 129 14
Felipe Anderson Pereira Gomes 4 Midfielder West Ham United 29 1993-04-15 130 36
Moussa Sissoko 3 Midfielder Tottenham Hotspur 33 1989-08-16 131 29
Fernando Luiz Rosa 3 Midfielder Manchester City 37 1985-05-04 132 29
Chris Mepham 1 Defender AFC Bournemouth 24 1997-11-05 133 13
Jordon Ibe 1 Midfielder AFC Bournemouth 26 1995-12-08 134 19
Jesse Lingard 2 Midfielder Manchester United 29 1992-12-15 135 27
Jose Izquierdo 1 Forward Brighton & Hove Albion 30 1992-07-07 136 15
Nathan Redmond 4 Midfielder Southampton 28 1994-03-06 137 38
Morgan Schneiderlin 1 Midfielder Everton 32 1989-11-08 138 14
Ben Chilwell 4 Defender Leicester City 25 1996-12-21 139 36
Marc Albrighton 2 Midfielder Leicester City 32 1989-11-18 140 27
Anthony Martial 2 Forward Manchester United 26 1995-12-05 141 27
Christian Benteke 1 Forward Crystal Palace 31 1990-12-03 142 16
Jonjoe Kenny 1 Defender Everton 25 1997-03-15 143 10
Pedro Rodriguez 2 Midfielder Chelsea 35 1987-07-28 144 31
Dominic Calvert-Lewin 2 Forward Everton 25 1997-03-16 145 35
Beram Kayal 1 Midfielder Brighton & Hove Albion 34 1988-05-02 146 18
Josh Murphy 2 Forward Cardiff City 27 1995-02-24 147 29
Pierre-Emile Højbjerg 3 Midfielder Southampton 27 1995-08-05 148 31
Jonjo Shelvey 1 Midfielder Newcastle United 30 1992-02-27 149 16
Mateo Kovačić 2 Midfielder Chelsea 28 1994-05-06 150 32
Mesut Özil 2 Midfielder Arsenal 34 1988-10-15 151 24
Adama Traoré Diarra 1 Midfielder Wolverhampton Wanderers 26 1996-01-25 152 29
Etienne Capoue 3 Midfielder Watford 34 1988-07-11 153 33
Isaac Ajayi Success 1 Forward Watford 26 1996-01-07 154 30
Adam Masina 1 Defender Watford 28 1994-01-02 155 14
Frederico Rodrigues Santos 1 Midfielder Manchester United 29 1993-03-05 156 17
Joshua King 3 Forward AFC Bournemouth 30 1992-01-15 157 35
Aymeric Laporte 3 Defender Manchester City 28 1994-05-27 158 35
Nathaniel Mendez-Laing 1 Midfielder Cardiff City 30 1992-04-15 159 20
Aaron Wan-Bissaka 3 Midfielder Crystal Palace 24 1997-11-26 160 35
Cheikhou Kouyaté 2 Midfielder Crystal Palace 32 1989-12-21 161 31
Rúben Diogo Da Silva Neves 3 Midfielder Wolverhampton Wanderers 25 1997-03-13 162 35
Chris Löwe 2 Defender Huddersfield Town 33 1989-04-16 163 29
Sean Morrison 3 Defender Cardiff City 31 1991-01-08 164 34
Isaac Mbenza 1 Forward Huddersfield Town 26 1996-03-08 165 22
Fabinho 2 Midfielder Liverpool 29 1993-10-23 166 28
Ainsley Maitland-Niles 1 Midfielder Arsenal 25 1997-08-29 167 16
Pedro Obiang 1 Midfielder West Ham United 30 1992-03-27 168 24
Laurent Depoitre 1 Forward Huddersfield Town 33 1988-12-07 169 23
Theo Walcott 2 Forward Everton 33 1989-03-16 170 37
Jean Michau00ebl Seri 2 Midfielder Fulham 31 1991-07-19 171 32
Ashley Barnes 2 Forward Burnley 32 1989-10-30 172 37
Sokratis Papastathopoulos 2 Defender Arsenal 34 1988-06-09 173 25
Lucas Torreira 2 Midfielder Arsenal 26 1996-02-11 174 34
Bruno Saltor Grau 1 Defender Brighton & Hove Albion 42 1980-10-01 175 14
Aleksandar Mitrović 3 Forward Fulham 28 1994-09-16 176 37
DeAndre Yedlin 2 Defender Newcastle United 29 1993-07-09 177 29
Séamus Coleman 2 Defender Everton 34 1988-10-11 178 29
Sung-Yeung Ki 1 Midfielder Newcastle United 33 1989-01-24 179 18
Nathaniel Clyne 1 Defender AFC Bournemouth 31 1991-04-05 180 18
Ashley Young 2 Midfielder Manchester United 37 1985-07-09 181 30
Shane Long 1 Forward Southampton 35 1987-01-22 182 26
Granit Xhaka 2 Midfielder Arsenal 30 1992-09-27 183 29
Robert Kenedy Nunes do Nascimento 1 Midfielder Newcastle United 26 1996-02-08 184 25
Kurt Zouma 2 Defender Everton 28 1994-10-27 185 32
Javier Hernandez 1 Forward West Ham United 34 1988-06-01 186 25
Aaron Lennon 1 Midfielder Burnley 35 1987-04-16 187 16
Chris Wood 2 Forward Burnley 30 1991-12-07 188 38
Phil Jones 1 Defender Manchester United 30 1992-02-21 189 18
Naby Deco Keïta 1 Midfielder Liverpool 27 1995-02-10 190 25
Aaron Cresswell 1 Defender West Ham United 32 1989-12-15 191 20
Maya Yoshida 1 Defender Southampton 34 1988-08-24 192 17
Idrissa Gana Gueye 2 Midfielder Everton 33 1989-09-26 193 33
Federico Fernández 1 Defender Newcastle United 33 1989-02-21 194 19
Mario Lemina 1 Midfielder Southampton 29 1993-09-01 195 21
Michael Keane 2 Defender Everton 29 1993-01-11 196 33
Ayoze Perez 2 Forward Newcastle United 29 1993-07-29 197 37
David Luiz 2 Defender Chelsea 35 1987-04-22 198 36
Patrick van Aanholt 2 Defender Crystal Palace 32 1990-08-29 199 36
Bernardo 1 Defender Brighton & Hove Albion 27 1995-05-14 200 22
Virgil van Dijk 2 Defender Liverpool 31 1991-07-08 201 38
Callum Paterson 1 Defender Cardiff City 28 1994-10-13 202 27
Arthur Masuaku 1 Defender West Ham United 28 1993-11-07 203 23
Jack Cork 2 Midfielder Burnley 33 1989-06-25 204 37
Cyrus Christie 1 Defender Fulham 30 1992-09-30 205 28
Dan Gosling 1 Midfielder AFC Bournemouth 32 1990-02-01 206 25
Angelo Ogbonna 1 Defender West Ham United 34 1988-05-23 207 24
Davinson Sánchez Mina 1 Defender Tottenham Hotspur 26 1996-06-12 208 23
Jeffrey Schlupp 1 Defender Crystal Palace 29 1992-12-23 209 30
Luka Milivojević 2 Midfielder Crystal Palace 31 1991-04-07 210 38
Ben Mee 2 Defender Burnley 33 1989-09-21 211 38
Demarai Gray 1 Midfielder Leicester City 26 1996-06-28 212 34
André Filipe Tavares Gomes 1 Midfielder Everton 29 1993-07-30 213 27
Yann Valery 1 Defender Southampton 23 1999-02-22 214 23
James Tomkins 1 Defender Crystal Palace 33 1989-03-29 215 29
Francisco Femenía Far 1 Midfielder Watford 31 1991-02-02 216 29
Tom Cairney 1 Midfielder Fulham 31 1991-01-20 217 31
Joe Bryan 1 Defender Fulham 29 1993-09-17 218 28
Maxime Le Marchand 1 Defender Fulham 33 1989-10-11 219 26
David Junior Hoilett 1 Forward Cardiff City 32 1990-06-05 220 32
Harry Arter 1 Midfielder Cardiff City 32 1989-12-28 221 25
Souleymane Bamba 1 Defender Cardiff City 37 1985-01-13 222 28
Pablo Zabaleta 1 Defender West Ham United 37 1985-01-16 223 26
Dale Stephens 1 Midfielder Brighton & Hove Albion 33 1989-06-12 224 30
Jan Bednarek 1 Defender Southampton 26 1996-04-12 225 25
Davy Pröpper 1 Midfielder Brighton & Hove Albion 31 1991-09-02 226 30
Glenn Murray 1 Forward Brighton & Hove Albion 39 1983-09-25 227 38
Adam Smith 1 Defender AFC Bournemouth 31 1991-04-29 228 25
Martín Montoya 1 Defender Brighton & Hove Albion 31 1991-04-14 229 25
Fabian Schär 1 Defender Newcastle United 30 1991-12-20 230 24
Jonathan Hogg 1 Midfielder Huddersfield Town 33 1988-12-06 231 29
Erik Durm 1 Defender Huddersfield Town 30 1992-05-12 232 28
Aaron Mooy 1 Midfielder Huddersfield Town 32 1990-09-15 233 29
Aron Einar Gunnarsson 1 Midfielder Cardiff City 33 1989-04-22 234 28
Mathias Jattah-Njie Jørgensen 1 Defender Huddersfield Town 32 1990-04-23 235 24
Terence Kongolo 1 Defender Huddersfield Town 28 1994-02-14 236 32
Jonny 1 Defender Wolverhampton Wanderers 28 1994-03-03 237 33
James Tarkowski 1 Defender Burnley 29 1992-11-19 238 35
Charlie Taylor 1 Defender Burnley 29 1993-09-18 239 38
Ederson 1 Goalkeeper Manchester City 29 1993-08-17 240 38
Joe Bennett 1 Defender Cardiff City 32 1990-03-28 241 30
Bruno Écuélé Manga 1 Defender Cardiff City 34 1988-07-16 242 38
Steve Cook 1 Defender AFC Bournemouth 31 1991-04-19 243 31
Denis Odoi 1 Defender Fulham 34 1988-05-27 244 31
Jamal Lascelles 1 Defender Newcastle United 28 1993-11-11 245 32
Victor Nilsson Lindelöf 1 Defender Manchester United 28 1994-07-17 246 30
Jonas Lössl 1 Goalkeeper Huddersfield Town 33 1989-02-01 247 31
Kyle Walker 1 Defender Manchester City 32 1990-05-28 248 33
Sadio Mané 1 Forward Liverpool 30 1992-04-10 249 36
Richarlison de Andrade 1 Forward Everton 25 1997-05-10 250 35
Roberto Maximiliano Pereyra 1 Forward Watford 31 1991-01-07 251 33
Lewis Dunk 1 Defender Brighton & Hove Albion 30 1991-11-21 252 36
Shane Duffy 1 Defender Brighton & Hove Albion 30 1992-01-01 253 35
Charlie Daniels 0 Defender AFC Bournemouth 36 1986-09-07 254 21
Alfie Mawson 0 Defender Fulham 28 1994-01-19 255 15
Antonio Valencia 0 Defender Manchester United 37 1985-08-04 256 6
Nemanja Matić 0 Midfielder Manchester United 34 1988-08-01 257 28
Jason Puncheon 0 Midfielder Huddersfield Town 36 1986-06-26 258 11
Elias Kachunga 0 Forward Huddersfield Town 30 1992-04-22 259 20
Jordan Pickford 0 Goalkeeper Everton 28 1994-03-07 260 38
Diego Rico 0 Defender AFC Bournemouth 29 1993-02-23 261 12
Kadeem Harris 0 Midfielder Cardiff City 29 1993-06-08 262 13
Sean Longstaff 0 Midfielder Newcastle United 25 1997-10-30 263 9
Romain Saïss 0 Midfielder Wolverhampton Wanderers 32 1990-03-26 264 19
José Luis Sanmartín Mato 0 Forward Newcastle United 32 1990-03-27 265 16
Victor Wanyama 0 Midfielder Tottenham Hotspur 31 1991-06-25 266 13
Mohamed Diamé 0 Midfielder Newcastle United 35 1987-06-14 267 29
Floyd Ayité 0 Midfielder Fulham 33 1988-12-15 268 16
Paul Dummett 0 Defender Newcastle United 31 1991-09-26 269 26
Alireza Jahanbakhsh 0 Forward Brighton & Hove Albion 29 1993-08-11 270 19
Christian Atsu Twasam 0 Midfielder Newcastle United 30 1992-01-10 271 28
Phil Jagielka 0 Defender Everton 40 1982-08-17 272 7
Asmir Begović 0 Goalkeeper AFC Bournemouth 35 1987-06-20 273 24
Ben Davies 0 Defender Tottenham Hotspur 29 1993-04-24 274 27
Toby Alderweireld 0 Defender Tottenham Hotspur 33 1989-03-02 275 34
Lucas Perez 0 Forward West Ham United 34 1988-09-10 276 15
Moussa Dembele 0 Midfielder Tottenham Hotspur 35 1987-07-16 277 10
Eric Dier 0 Midfielder Tottenham Hotspur 28 1994-01-15 278 20
Lucas Rodrigues Moura da Silva 0 Midfielder Tottenham Hotspur 30 1992-08-13 279 32
Matteo Darmian 0 Defender Manchester United 32 1989-12-02 280 6
Jürgen Locadia 0 Forward Brighton & Hove Albion 28 1993-11-07 281 26
Jan Vertonghen 0 Defender Tottenham Hotspur 35 1987-04-24 282 22
Marcus Bettinelli 0 Goalkeeper Fulham 30 1992-05-24 283 7
Hugo Lloris 0 Goalkeeper Tottenham Hotspur 35 1986-12-26 284 33
André-Frank Zambo Anguissa 0 Midfielder Fulham 26 1995-11-16 285 22
Joel Matip 0 Defender Liverpool 31 1991-08-08 286 22
Leighton Baines 0 Defender Everton 37 1984-12-11 287 6
Jefferson Lerma 0 Midfielder AFC Bournemouth 28 1994-10-25 288 30
Florin Andone 0 Forward Brighton & Hove Albion 29 1993-04-11 289 23
Yoshinori Muto 0 Forward Newcastle United 30 1992-07-15 290 17
Jon Gorenc Stankovič 0 Defender Huddersfield Town 26 1996-01-14 291 11
Leon Balogun 0 Defender Brighton & Hove Albion 34 1988-06-28 292 8
Yves Bissouma 0 Midfielder Brighton & Hove Albion 26 1996-08-30 293 28
Chris Smalling 0 Defender Manchester United 32 1989-11-22 294 24
Laurent Koscielny 0 Defender Arsenal 37 1985-09-10 295 17
Emerson Palmieri dos Santos 0 Defender Chelsea 28 1994-08-03 296 10
Hamza Choudhury 0 Midfielder Leicester City 25 1997-10-01 297 9
Tom Cleverley 0 Midfielder Watford 33 1989-08-12 298 13
Harry Maguire 0 Defender Leicester City 29 1993-03-05 299 31
Wes Morgan 0 Defender Leicester City 38 1984-01-21 300 22
Florian Lejeune 0 Defender Newcastle United 31 1991-05-20 301 12
Kasper Schmeichel 0 Goalkeeper Leicester City 35 1986-11-05 302 38
Scott McTominay 0 Midfielder Manchester United 25 1996-12-08 303 16
Ryan Bennett 0 Defender Wolverhampton Wanderers 32 1990-03-06 304 34
Romelu Lukaku 0 Forward Manchester United 29 1993-05-13 305 32
Gonzalo Higuain 0 Forward Chelsea 34 1987-12-10 306 14
Michy Batshuayi 0 Forward Crystal Palace 29 1993-10-02 307 11
Karlan Ahearne-Grant 0 Forward Huddersfield Town 24 1997-12-19 308 13
Leandro Bacuna 0 Midfielder Cardiff City 31 1991-08-21 309 11
Eric Bertrand Bailly 0 Defender Manchester United 28 1994-04-12 310 12
Miguel Ángel Almirón Rejala 0 Midfielder Newcastle United 28 1994-02-10 311 10
Willy Boly 0 Defender Wolverhampton Wanderers 31 1991-02-03 312 36
Daniel Amartey 0 Midfielder Leicester City 27 1994-12-21 313 9
Jack Simpson 0 Defender AFC Bournemouth 25 1996-12-18 314 6
Ciaran Clark 0 Defender Newcastle United 33 1989-09-26 315 11
Domingos Quina 0 Midfielder Watford 22 1999-11-18 316 8
Martin Dúbravka 0 Goalkeeper Newcastle United 33 1989-01-15 317 38
Danilo 0 Defender Manchester City 31 1991-07-15 318 11
Jonny Evans 0 Defender Leicester City 34 1988-01-03 319 24
Tim Ream 0 Defender Fulham 35 1987-10-05 320 26
Steven Defour 0 Midfielder Burnley 34 1988-04-15 321 6
Rachid Ghezzal 0 Forward Leicester City 30 1992-05-09 322 19
Rúben Gonçalo Silva Nascimento Vinagre 0 Defender Wolverhampton Wanderers 23 1999-04-09 323 17
Dejan Lovren 0 Defender Liverpool 33 1989-07-05 324 13
Juninho Bacuna 0 Midfielder Huddersfield Town 25 1997-08-07 325 21
Andy Carroll 0 Forward West Ham United 33 1989-01-06 326 12
David Button 0 Goalkeeper Brighton & Hove Albion 33 1989-02-27 327 4
Rui Pedro dos Santos Patrício 0 Goalkeeper Wolverhampton Wanderers 34 1988-02-15 328 37
Yerry Fernando Mina González 0 Defender Everton 28 1994-09-23 329 13
Caglar Söyüncü 0 Defender Leicester City 26 1996-05-23 330 6
Leander Dendoncker 0 Midfielder Wolverhampton Wanderers 27 1995-04-15 331 19
Onyinye Wilfred Ndidi 0 Midfielder Leicester City 25 1996-12-16 332 38
Danny Simpson 0 Defender Leicester City 35 1987-01-04 333 6
Juan Marcos Foyth 0 Defender Tottenham Hotspur 24 1998-01-12 334 12
Harry Winks 0 Midfielder Tottenham Hotspur 26 1996-02-02 335 26
Gaëtan Bong Songo 0 Defender Brighton & Hove Albion 34 1988-04-25 336 22
Nathan Aké 0 Defender AFC Bournemouth 27 1995-02-18 337 38
Alvaro Morata 0 Forward Chelsea 30 1992-10-23 338 16
Angus Gunn 0 Goalkeeper Southampton 26 1996-01-22 339 12
Ryan Fredericks 0 Midfielder West Ham United 30 1992-10-10 340 15
Joe Hart 0 Goalkeeper Burnley 35 1987-04-19 341 19
Matthew Lowton 0 Defender Burnley 33 1989-06-09 342 21
Łukasz Fabiański 0 Goalkeeper West Ham United 37 1985-04-18 343 38
Adam David Lallana 0 Midfielder Liverpool 34 1988-05-10 344 13
Christopher Schindler 0 Defender Huddersfield Town 32 1990-04-29 345 37
Andreas Christensen 0 Defender Chelsea 26 1996-04-10 346 8
James Ward-Prowse 0 Midfielder Southampton 27 1994-11-01 347 26
Ben Hamer 0 Goalkeeper Huddersfield Town 34 1987-11-20 348 7
Jeff Hendrick 0 Midfielder Burnley 30 1992-01-31 349 32
Martin Kelly 0 Defender Crystal Palace 32 1990-04-27 350 13
Sam Vokes 0 Forward Burnley 33 1989-10-21 351 20
Vicente Guaita 0 Goalkeeper Crystal Palace 35 1987-01-10 352 20
Ben Foster 0 Goalkeeper Watford 39 1983-04-03 353 38
Tom Heaton 0 Goalkeeper Burnley 36 1986-04-15 354 19
Phil Bardsley 0 Defender Burnley 37 1985-06-28 355 19
Fabián Cornelio Balbuena González 0 Defender West Ham United 31 1991-08-23 356 23
Manolo Gabbiadini 0 Forward Southampton 30 1991-11-26 357 12
Joel Ward 0 Defender Crystal Palace 32 1989-10-29 358 7
Adama Diakhaby 0 Forward Huddersfield Town 26 1996-07-05 359 12
Tom Smith 0 Defender Huddersfield Town 30 1992-04-14 360 15
Andriy Yarmolenko 0 Forward West Ham United 33 1989-10-23 361 9
Declan Rice 0 Midfielder West Ham United 23 1999-01-14 362 34
Kepa Arrizabalaga 0 Goalkeeper Chelsea 28 1994-10-03 363 36
Issa Diop 0 Defender West Ham United 25 1997-01-09 364 33
Alex McCarthy 0 Goalkeeper Southampton 32 1989-12-03 365 25
Ryan Bertrand 0 Defender Southampton 33 1989-08-05 366 24
Jannik Vestergaard 0 Defender Southampton 30 1992-08-03 367 23
Mohamed Elyounoussi 0 Midfielder Southampton 28 1994-08-04 368 16
Jack Stephens 0 Defender Southampton 28 1994-01-27 369 24
Wesley Hoedt 0 Defender Southampton 28 1994-03-06 370 13
Oriol Romeu 0 Midfielder Southampton 31 1991-09-24 371 31
Philip Billing 0 Midfielder Huddersfield Town 26 1996-06-11 372 27
Alex Pritchard 0 Midfielder Huddersfield Town 29 1993-05-03 373 30
Antonio Rüdiger 0 Defender Chelsea 29 1993-03-03 374 33
Jorginho 0 Midfielder Chelsea 30 1991-12-20 375 37
Florent Hadergjonaj 0 Defender Huddersfield Town 28 1994-07-31 376 24
Petr Čech 0 Goalkeeper Arsenal 40 1982-05-20 377 7
Shkodran Mustafi 0 Defender Arsenal 30 1992-04-17 378 31
Andrew Surman 0 Midfielder AFC Bournemouth 36 1986-08-20 379 18
Tom Davies 0 Midfielder Everton 24 1998-06-30 380 16
Greg Cunningham 0 Defender Cardiff City 31 1991-01-31 381 7
Danny Ward 0 Forward Cardiff City 31 1990-12-09 382 14
Joe Ralls 0 Midfielder Cardiff City 29 1993-10-13 383 28
Vincent Kompany 0 Defender Manchester City 36 1986-04-10 384 17
Nicolas Otamendi 0 Defender Manchester City 34 1988-02-12 385 18
Philip Foden 0 Midfielder Manchester City 22 2000-05-28 386 13
Alisson Becker 0 Goalkeeper Liverpool 30 1992-10-02 387 38
Oumar Niasse 0 Forward Cardiff City 32 1990-04-18 388 18
Mathew Ryan 0 Goalkeeper Brighton & Hove Albion 30 1992-04-08 389 34
Mason Holgate 0 Defender Everton 26 1996-10-22 390 5
Lee Peltier 0 Defender Cardiff City 35 1986-12-11 391 20
Neil Leonard Dula Etheridge 0 Goalkeeper Cardiff City 32 1990-02-07 392 38
Lewis Cook 0 Midfielder AFC Bournemouth 25 1997-02-03 393 13
Artur Boruc 0 Goalkeeper AFC Bournemouth 42 1980-02-20 394 12
Lys Mousset 0 Forward AFC Bournemouth 26 1996-02-08 395 24
Rajiv van La Parra 0 Midfielder Huddersfield Town 31 1991-06-04 396 5
Nampalys Mendy 0 Midfielder Leicester City 30 1992-06-23 397 31
Joe Gomez 0 Defender Liverpool 25 1997-05-23 398 16
Calum Chambers 0 Defender Fulham 27 1995-01-20 399 31
Craig Cathcart 0 Defender Watford 33 1989-02-06 400 36
Stefan Marius Johansen 0 Midfielder Fulham 31 1991-01-08 401 12
Christian Kabasele 0 Defender Watford 31 1991-02-24 402 21
Mamadou Sakho 0 Defender Crystal Palace 32 1990-02-13 403 27
Wayne Hennessey 0 Goalkeeper Crystal Palace 35 1987-01-24 404 18
Mattéo Guendouzi Olié 0 Midfielder Arsenal 23 1999-04-14 405 33
Sergio Rico 0 Goalkeeper Fulham 29 1993-09-01 406 29
Stephan Lichtsteiner 0 Defender Arsenal 38 1984-01-16 407 14
Timothy Fosu-Mensah 0 Defender Fulham 24 1998-01-02 408 12
Mohamed Elneny 0 Midfielder Arsenal 30 1992-07-11 409 8
Kevin McDonald 0 Midfielder Fulham 33 1988-11-04 410 15
Rob Holding 0 Defender Arsenal 27 1995-09-20 411 10
Aboubakar Kamara 0 Forward Fulham 27 1995-03-07 412 13
Bernd Leno 0 Goalkeeper Arsenal 30 1992-03-04 413 32
Adrian Mariappa 0 Defender Watford 36 1986-10-03 414 26
Conor Coady 0 Midfielder Wolverhampton Wanderers 29 1993-02-25 415 38
Georginio Wijnaldum 0 Midfielder Liverpool 31 1990-11-11 416 35
André Schürrle 0 Midfielder Fulham 31 1990-11-06 417 24
John Stones 0 Defender Manchester City 28 1994-05-28 418 24
David de Gea 0 Goalkeeper Manchester United 31 1990-11-07 419 38

Best Defender

A defenders main job is in its name they are the front line between the strikers and the goalie so they must do all in their power to make sure the ball does not get past them. If they are able to do this they can get a clean sheet meaning no balls get scored on them.

Defend <- filter(df, rank_in_league_top_defenders != -1) %>% 
  select(c('full_name','clean_sheets_overall','position','current_club','age','birthday_gmt', 'rank_in_league_top_defenders', 'appearances_overall' )) 

DefendClean <- Defend[order(Defend$rank_in_league_top_defenders),]

kable(DefendClean, format = "html" , caption = "Top league Defenders",align = "cccccccccccccccc") %>% kable_styling()
Top league Defenders
full_name clean_sheets_overall position current_club age birthday_gmt rank_in_league_top_defenders appearances_overall
Joe Gomez 11 Defender Liverpool 25 1997-05-23 1 16
Andrew Robertson 21 Defender Liverpool 28 1994-03-11 2 36
Alisson Becker 21 Goalkeeper Liverpool 30 1992-10-02 3 38
Nicolas Otamendi 10 Defender Manchester City 34 1988-02-12 4 18
Virgil van Dijk 21 Defender Liverpool 31 1991-07-08 5 38
Trent Alexander-Arnold 16 Defender Liverpool 24 1998-10-07 6 29
Vincent Kompany 7 Defender Manchester City 36 1986-04-10 7 17
Joel Matip 11 Defender Liverpool 31 1991-08-08 8 22
Phil Jagielka 5 Defender Everton 40 1982-08-17 9 7
Kyle Walker 18 Defender Manchester City 32 1990-05-28 10 33
Danny Rose 10 Defender Tottenham Hotspur 32 1990-07-02 11 26
Benjamin Mendy 4 Defender Manchester City 28 1994-07-17 12 10
Ederson 20 Goalkeeper Manchester City 29 1993-08-17 13 38
Aymeric Laporte 18 Defender Manchester City 28 1994-05-27 14 35
Dejan Lovren 6 Defender Liverpool 33 1989-07-05 15 13
Caglar Söyüncü 2 Defender Leicester City 26 1996-05-23 16 6
John Stones 13 Defender Manchester City 28 1994-05-28 17 24
Danilo 5 Defender Manchester City 31 1991-07-15 18 11
Kieran Trippier 10 Defender Tottenham Hotspur 32 1990-09-19 19 27
Toby Alderweireld 12 Defender Tottenham Hotspur 33 1989-03-02 20 34
Hugo Lloris 12 Goalkeeper Tottenham Hotspur 35 1986-12-26 21 33
Marcos Alonso 14 Defender Chelsea 31 1990-12-28 22 31
Fabian Schär 8 Defender Newcastle United 30 1991-12-20 23 24
Scott Dann 3 Defender Crystal Palace 35 1987-02-14 24 10
Kyle Walker-Peters 3 Defender Tottenham Hotspur 25 1997-04-13 25 6
Davinson Sánchez Mina 6 Defender Tottenham Hotspur 26 1996-06-12 26 23
David Luiz 16 Defender Chelsea 35 1987-04-22 27 36
Juan Marcos Foyth 4 Defender Tottenham Hotspur 24 1998-01-12 28 12
Antonio Valencia 2 Defender Manchester United 37 1985-08-04 29 6
Javier Manquillo Gaitán 6 Defender Newcastle United 28 1994-05-05 30 18
Jan Vertonghen 7 Defender Tottenham Hotspur 35 1987-04-24 31 22
Jonny Evans 8 Defender Leicester City 34 1988-01-03 32 24
Cesar Azpilicueta 16 Defender Chelsea 33 1989-08-28 33 38
Séamus Coleman 13 Defender Everton 34 1988-10-11 34 29
Andreas Christensen 3 Defender Chelsea 26 1996-04-10 35 8
Florian Lejeune 3 Defender Newcastle United 31 1991-05-20 36 12
Nacho Monreal 6 Defender Arsenal 36 1986-02-26 37 22
Antonio Rüdiger 12 Defender Chelsea 29 1993-03-03 38 33
Kepa Arrizabalaga 14 Goalkeeper Chelsea 28 1994-10-03 39 36
Ryan Bennett 9 Defender Wolverhampton Wanderers 32 1990-03-06 40 34
Jamal Lascelles 11 Defender Newcastle United 28 1993-11-11 41 32
Lucas Digne 14 Defender Everton 29 1993-07-20 42 35
Willy Boly 8 Defender Wolverhampton Wanderers 31 1991-02-03 43 36
Ben Chilwell 10 Defender Leicester City 25 1996-12-21 44 36
Vicente Guaita 7 Goalkeeper Crystal Palace 35 1987-01-10 45 20
Matt Doherty 9 Defender Wolverhampton Wanderers 30 1992-01-16 46 38
Rob Holding 2 Defender Arsenal 27 1995-09-20 47 10
Wes Morgan 6 Defender Leicester City 38 1984-01-21 48 22
Michael Keane 13 Defender Everton 29 1993-01-11 49 33
Kasper Schmeichel 10 Goalkeeper Leicester City 35 1986-11-05 50 38
Phil Jones 4 Defender Manchester United 30 1992-02-21 51 18
Ricardo Domingos Barbosa Pereira 10 Defender Leicester City 29 1993-10-06 52 35
Patrick van Aanholt 12 Defender Crystal Palace 32 1990-08-29 53 36
Rúben Gonçalo Silva Nascimento Vinagre 5 Defender Wolverhampton Wanderers 23 1999-04-09 54 17
Issa Diop 7 Defender West Ham United 25 1997-01-09 55 33
Rui Pedro dos Santos Patrício 8 Goalkeeper Wolverhampton Wanderers 34 1988-02-15 56 37
Jordan Pickford 14 Goalkeeper Everton 28 1994-03-07 57 38
Martin Dúbravka 11 Goalkeeper Newcastle United 33 1989-01-15 58 38
Jonny 8 Defender Wolverhampton Wanderers 28 1994-03-03 59 33
Ben Davies 10 Defender Tottenham Hotspur 29 1993-04-24 60 27
Hector Bellerin 4 Defender Arsenal 27 1995-03-19 61 19
Phil Bardsley 4 Defender Burnley 37 1985-06-28 62 19
James Tomkins 10 Defender Crystal Palace 33 1989-03-29 63 29
Mamadou Sakho 9 Defender Crystal Palace 32 1990-02-13 64 27
Jannik Vestergaard 4 Defender Southampton 30 1992-08-03 65 23
Fabián Cornelio Balbuena González 5 Defender West Ham United 31 1991-08-23 66 23
Yerry Fernando Mina González 4 Defender Everton 28 1994-09-23 67 13
Tom Heaton 4 Goalkeeper Burnley 36 1986-04-15 68 19
Paul Dummett 9 Defender Newcastle United 31 1991-09-26 69 26
Kevin Long 1 Defender Burnley 32 1990-08-18 70 6
Petr Čech 2 Goalkeeper Arsenal 40 1982-05-20 71 7
Lee Peltier 6 Defender Cardiff City 35 1986-12-11 72 20
Danny Simpson 3 Defender Leicester City 35 1987-01-04 73 6
Shkodran Mustafi 6 Defender Arsenal 30 1992-04-17 74 31
Sead Kolašinac 5 Defender Arsenal 29 1993-06-20 75 24
Bernd Leno 7 Goalkeeper Arsenal 30 1992-03-04 76 32
Luke Shaw 6 Defender Manchester United 27 1995-07-12 77 29
Harry Maguire 7 Defender Leicester City 29 1993-03-05 78 31
David Button 1 Goalkeeper Brighton & Hove Albion 33 1989-02-27 79 4
Aaron Cresswell 3 Defender West Ham United 32 1989-12-15 80 20
Łukasz Fabiański 7 Goalkeeper West Ham United 37 1985-04-18 81 38
Sokratis Papastathopoulos 6 Defender Arsenal 34 1988-06-09 82 25
Kurt Zouma 11 Defender Everton 28 1994-10-27 83 32
Daryl Janmaat 3 Defender Watford 33 1989-07-22 84 18
Adam Smith 9 Defender AFC Bournemouth 31 1991-04-29 85 25
Jeffrey Schlupp 8 Defender Crystal Palace 29 1992-12-23 86 30
Wayne Hennessey 5 Goalkeeper Crystal Palace 35 1987-01-24 87 18
Victor Nilsson Lindelöf 6 Defender Manchester United 28 1994-07-17 88 30
Arthur Masuaku 6 Defender West Ham United 28 1993-11-07 89 23
Federico Fernández 4 Defender Newcastle United 33 1989-02-21 90 19
David de Gea 7 Goalkeeper Manchester United 31 1990-11-07 91 38
Bruno Saltor Grau 4 Defender Brighton & Hove Albion 42 1980-10-01 92 14
DeAndre Yedlin 6 Defender Newcastle United 29 1993-07-09 93 29
Adrian Mariappa 6 Defender Watford 36 1986-10-03 94 26
Yann Valery 3 Defender Southampton 23 1999-02-22 95 23
Emerson Palmieri dos Santos 3 Defender Chelsea 28 1994-08-03 96 10
Leon Balogun 0 Defender Brighton & Hove Albion 34 1988-06-28 97 8
Jan Bednarek 3 Defender Southampton 26 1996-04-12 98 25
Pablo Zabaleta 4 Defender West Ham United 37 1985-01-16 99 26
Artur Boruc 4 Goalkeeper AFC Bournemouth 42 1980-02-20 100 12
Christian Kabasele 4 Defender Watford 31 1991-02-24 101 21
Matteo Darmian 1 Defender Manchester United 32 1989-12-02 102 6
Laurent Koscielny 4 Defender Arsenal 37 1985-09-10 103 17
Angus Gunn 3 Goalkeeper Southampton 26 1996-01-22 104 12
José Holebas 5 Defender Watford 38 1984-06-27 105 28
Chris Smalling 4 Defender Manchester United 32 1989-11-22 106 24
Bernardo 4 Defender Brighton & Hove Albion 27 1995-05-14 107 22
Serge Aurier 3 Defender Tottenham Hotspur 29 1992-12-24 108 8
Leighton Baines 1 Defender Everton 37 1984-12-11 109 6
Martin Kelly 3 Defender Crystal Palace 32 1990-04-27 110 13
Charlie Taylor 8 Defender Burnley 29 1993-09-18 111 38
Joe Bennett 9 Defender Cardiff City 32 1990-03-28 112 30
Ciaran Clark 2 Defender Newcastle United 33 1989-09-26 113 11
Alex McCarthy 4 Goalkeeper Southampton 32 1989-12-03 114 25
Shane Duffy 7 Defender Brighton & Hove Albion 30 1992-01-01 115 35
Ben Foster 7 Goalkeeper Watford 39 1983-04-03 116 38
Ryan Bertrand 6 Defender Southampton 33 1989-08-05 117 24
Ben Mee 8 Defender Burnley 33 1989-09-21 118 38
Craig Cathcart 6 Defender Watford 33 1989-02-06 119 36
Lewis Dunk 7 Defender Brighton & Hove Albion 30 1991-11-21 120 36
James Tarkowski 7 Defender Burnley 29 1992-11-19 121 35
Mathew Ryan 6 Goalkeeper Brighton & Hove Albion 30 1992-04-08 122 34
Wesley Hoedt 4 Defender Southampton 28 1994-03-06 123 13
Angelo Ogbonna 3 Defender West Ham United 34 1988-05-23 124 24
Mathias Jattah-Njie Jørgensen 3 Defender Huddersfield Town 32 1990-04-23 125 24
Bruno Écuélé Manga 10 Defender Cardiff City 34 1988-07-16 126 38
Cedric Soares 5 Defender Southampton 31 1991-08-31 127 18
Martín Montoya 3 Defender Brighton & Hove Albion 31 1991-04-14 128 25
Jonjoe Kenny 2 Defender Everton 25 1997-03-15 129 10
Jack Stephens 5 Defender Southampton 28 1994-01-27 130 24
José Diogo Dalot Teixeira 2 Defender Manchester United 23 1999-03-18 131 16
Gaëtan Bong Songo 5 Defender Brighton & Hove Albion 34 1988-04-25 132 22
Maya Yoshida 3 Defender Southampton 34 1988-08-24 133 17
Neil Leonard Dula Etheridge 10 Goalkeeper Cardiff City 32 1990-02-07 134 38
Florent Hadergjonaj 4 Defender Huddersfield Town 28 1994-07-31 135 24
Souleymane Bamba 7 Defender Cardiff City 37 1985-01-13 136 28
Callum Paterson 7 Defender Cardiff City 28 1994-10-13 137 27
Simon Francis 5 Defender AFC Bournemouth 37 1985-02-16 138 17
Jonas Lössl 5 Goalkeeper Huddersfield Town 33 1989-02-01 139 31
Sean Morrison 9 Defender Cardiff City 31 1991-01-08 140 34
Eric Bertrand Bailly 3 Defender Manchester United 28 1994-04-12 141 12
Chris Mepham 3 Defender AFC Bournemouth 24 1997-11-05 142 13
Calum Chambers 5 Defender Fulham 27 1995-01-20 143 31
Adam Masina 2 Defender Watford 28 1994-01-02 144 14
Steve Cook 9 Defender AFC Bournemouth 31 1991-04-19 145 31
Nathaniel Clyne 6 Defender AFC Bournemouth 31 1991-04-05 146 18
Stephan Lichtsteiner 2 Defender Arsenal 38 1984-01-16 147 14
Nathan Aké 10 Defender AFC Bournemouth 27 1995-02-18 148 38
Joe Hart 4 Goalkeeper Burnley 35 1987-04-19 149 19
Matthew Lowton 4 Defender Burnley 33 1989-06-09 150 21
Matt Targett 1 Defender Southampton 27 1995-09-18 151 16
Charlie Daniels 6 Defender AFC Bournemouth 36 1986-09-07 152 21
Sergio Rico 5 Goalkeeper Fulham 29 1993-09-01 153 29
Asmir Begović 5 Goalkeeper AFC Bournemouth 35 1987-06-20 154 24
Cyrus Christie 5 Defender Fulham 30 1992-09-30 155 28
Erik Durm 3 Defender Huddersfield Town 30 1992-05-12 156 28
Christopher Schindler 5 Defender Huddersfield Town 32 1990-04-29 157 37
Joe Bryan 5 Defender Fulham 29 1993-09-17 158 28
Joel Ward 0 Defender Crystal Palace 32 1989-10-29 159 7
Mason Holgate 0 Defender Everton 26 1996-10-22 160 5
Alfie Mawson 3 Defender Fulham 28 1994-01-19 161 15
Maxime Le Marchand 4 Defender Fulham 33 1989-10-11 162 26
Jack Simpson 2 Defender AFC Bournemouth 25 1996-12-18 163 6
Timothy Fosu-Mensah 1 Defender Fulham 24 1998-01-02 164 12
Terence Kongolo 4 Defender Huddersfield Town 28 1994-02-14 165 32
Denis Odoi 5 Defender Fulham 34 1988-05-27 166 31
Tim Ream 5 Defender Fulham 35 1987-10-05 167 26
Ryan Sessegnon 4 Defender Fulham 22 2000-05-18 168 35
Chris Löwe 1 Defender Huddersfield Town 33 1989-04-16 169 29
Greg Cunningham 1 Defender Cardiff City 31 1991-01-31 170 7
Jon Gorenc Stankovič 2 Defender Huddersfield Town 26 1996-01-14 171 11
Diego Rico 0 Defender AFC Bournemouth 29 1993-02-23 172 12
Tom Smith 1 Defender Huddersfield Town 30 1992-04-14 173 15
Marcus Bettinelli 0 Goalkeeper Fulham 30 1992-05-24 174 7
Ben Hamer 1 Goalkeeper Huddersfield Town 34 1987-11-20 175 7

Best Scorer

A Scorer can be anyone as long as they shoot their shot and get it in they rank. These rankings in this section specifically focus on who is the best in their respective club (team).

Scorer <- filter(df, rank_in_club_top_scorer != -1) %>% 
  select(c('full_name','goals_overall','assists_overall','position','current_club','age','birthday_gmt', 'rank_in_club_top_scorer', 'appearances_overall' )) 

ScorerClean <- Scorer[order(Scorer$rank_in_club_top_scorer,-Scorer$goals_overall),]

kable(ScorerClean, format = "html" , caption = "Top league Scorer",align = "cccccccccccccccc") %>% kable_styling()
Top league Scorer
full_name goals_overall assists_overall position current_club age birthday_gmt rank_in_club_top_scorer appearances_overall
Pierre-Emerick Aubameyang 22 5 Forward Arsenal 33 1989-06-18 1 36
Sadio Mané 22 1 Forward Liverpool 30 1992-04-10 1 36
Sergio Aguero 21 8 Forward Manchester City 34 1988-06-02 1 33
Jamie Vardy 18 4 Forward Leicester City 35 1987-01-11 1 34
Harry Kane 17 4 Forward Tottenham Hotspur 29 1993-07-28 1 28
Eden Hazard 16 15 Midfielder Chelsea 31 1991-01-07 1 37
Callum Wilson 14 9 Forward AFC Bournemouth 30 1992-02-27 1 30
Glenn Murray 13 1 Forward Brighton & Hove Albion 39 1983-09-25 1 38
Paul Pogba 13 9 Midfielder Manchester United 29 1993-03-15 1 35
Raúl Alonso Jiménez Rodríguez 13 7 Forward Wolverhampton Wanderers 31 1991-05-05 1 38
Richarlison de Andrade 13 1 Forward Everton 25 1997-05-10 1 35
Ashley Barnes 12 2 Forward Burnley 32 1989-10-30 1 37
Ayoze Perez 12 2 Forward Newcastle United 29 1993-07-29 1 37
Luka Milivojević 12 2 Midfielder Crystal Palace 31 1991-04-07 1 38
Aleksandar Mitrović 11 3 Forward Fulham 28 1994-09-16 1 37
Gerard Deulofeu 10 5 Forward Watford 28 1994-03-13 1 30
Marko Arnautović 10 4 Forward West Ham United 33 1989-04-19 1 28
James Ward-Prowse 7 0 Midfielder Southampton 27 1994-11-01 1 26
Víctor Camarasa 5 4 Midfielder Cardiff City 28 1994-05-28 1 32
Karlan Ahearne-Grant 4 0 Forward Huddersfield Town 24 1997-12-19 1 13
Mohamed Salah 22 8 Forward Liverpool 30 1992-06-15 2 38
Raheem Sterling 17 10 Forward Manchester City 27 1994-12-08 2 34
Alexandre Lacazette 13 8 Forward Arsenal 31 1991-05-28 2 35
Gylfi Sigurdsson 13 6 Midfielder Everton 33 1989-09-08 2 38
Heung-Min Son 12 6 Forward Tottenham Hotspur 30 1992-07-08 2 31
Joshua King 12 3 Forward AFC Bournemouth 30 1992-01-15 2 35
Romelu Lukaku 12 0 Forward Manchester United 29 1993-05-13 2 32
Rondon 11 7 Forward Newcastle United 33 1989-09-16 2 32
Chris Wood 10 2 Forward Burnley 30 1991-12-07 2 38
Wilfried Zaha 10 5 Midfielder Crystal Palace 29 1992-11-10 2 34
Diogo José Teixeira da Silva 9 5 Midfielder Wolverhampton Wanderers 25 1996-12-04 2 33
Felipe Anderson Pereira Gomes 9 4 Midfielder West Ham United 29 1993-04-15 2 36
Troy Deeney 9 5 Forward Watford 34 1988-06-29 2 32
Pedro Rodriguez 8 2 Midfielder Chelsea 35 1987-07-28 2 31
Daniel William John Ings 7 3 Forward Southampton 30 1992-07-23 2 24
James Maddison 7 7 Midfielder Leicester City 25 1996-11-23 2 36
André Schürrle 6 0 Midfielder Fulham 31 1990-11-06 2 24
Bobby Reid 5 2 Midfielder Cardiff City 29 1993-02-02 2 27
Shane Duffy 5 1 Defender Brighton & Hove Albion 30 1992-01-01 2 35
Mathias Jattah-Njie Jørgensen 3 1 Defender Huddersfield Town 32 1990-04-23 2 24
Roberto Firmino 12 6 Forward Liverpool 31 1991-10-02 3 34
Leroy Sané 10 10 Midfielder Manchester City 26 1996-01-11 3 31
Lucas Rodrigues Moura da Silva 10 0 Midfielder Tottenham Hotspur 30 1992-08-13 3 32
Marcus Rashford 10 6 Forward Manchester United 25 1997-10-31 3 33
Andre Gray 7 2 Forward Watford 31 1991-06-26 3 29
Javier Hernandez 7 1 Forward West Ham United 34 1988-06-01 3 25
Ryan Fraser 7 14 Midfielder AFC Bournemouth 28 1994-02-24 3 38
Andros Townsend 6 4 Midfielder Crystal Palace 31 1991-07-16 3 38
Dominic Calvert-Lewin 6 2 Forward Everton 25 1997-03-16 3 35
Henrikh Mkhitaryan 6 4 Midfielder Arsenal 33 1989-01-21 3 25
Nathan Redmond 6 4 Midfielder Southampton 28 1994-03-06 3 38
Ruben Loftus-Cheek 6 2 Midfielder Chelsea 26 1996-01-23 3 24
Ryan Guno Babel 5 3 Forward Fulham 35 1986-12-19 3 16
Callum Paterson 4 1 Defender Cardiff City 28 1994-10-13 3 27
Demarai Gray 4 1 Midfielder Leicester City 26 1996-06-28 3 34
Fabian Schär 4 1 Defender Newcastle United 30 1991-12-20 3 24
Rúben Diogo Da Silva Neves 4 3 Midfielder Wolverhampton Wanderers 25 1997-03-13 3 35
Aaron Mooy 3 1 Midfielder Huddersfield Town 32 1990-09-15 3 29
Florin Andone 3 0 Forward Brighton & Hove Albion 29 1993-04-11 3 23
Sam Vokes 3 0 Forward Burnley 33 1989-10-21 3 20
Anthony Martial 10 2 Forward Manchester United 26 1995-12-05 4 27
Christian Eriksen 8 12 Midfielder Tottenham Hotspur 30 1992-02-14 4 35
David Brooks 7 5 Forward AFC Bournemouth 25 1997-07-08 4 30
Gabriel Jesus 7 3 Forward Manchester City 25 1997-04-03 4 29
Michail Antonio 6 4 Midfielder West Ham United 32 1990-03-28 4 33
Roberto Maximiliano Pereyra 6 1 Forward Watford 31 1991-01-07 4 33
Xherdan Shaqiri 6 3 Midfielder Liverpool 31 1991-10-10 4 24
Alvaro Morata 5 0 Forward Chelsea 30 1992-10-23 4 16
Mesut Özil 5 2 Midfielder Arsenal 34 1988-10-15 4 24
Michy Batshuayi 5 0 Forward Crystal Palace 29 1993-10-02 4 11
Shane Long 5 1 Forward Southampton 35 1987-01-22 4 26
Theo Walcott 5 2 Forward Everton 33 1989-03-16 4 37
Souleymane Bamba 4 1 Defender Cardiff City 37 1985-01-13 4 28
Willy Boly 4 0 Defender Wolverhampton Wanderers 31 1991-02-03 4 36
Aboubakar Kamara 3 0 Forward Fulham 27 1995-03-07 4 13
Ciaran Clark 3 0 Defender Newcastle United 33 1989-09-26 4 11
James Tarkowski 3 1 Defender Burnley 29 1992-11-19 4 35
Pascal Groß 3 3 Midfielder Brighton & Hove Albion 31 1991-06-15 4 25
Youri Tielemans 3 4 Midfielder Leicester City 25 1997-05-07 4 13
Philip Billing 2 0 Midfielder Huddersfield Town 26 1996-06-11 4 27
Bernardo Silva 7 7 Midfielder Manchester City 28 1994-08-10 5 36
Abdoulaye Doucouré 5 6 Midfielder Watford 29 1993-01-01 5 35
Dele Alli 5 3 Midfielder Tottenham Hotspur 26 1996-04-11 5 25
Gonzalo Higuain 5 0 Forward Chelsea 34 1987-12-10 5 14
James Milner 5 4 Midfielder Liverpool 36 1986-01-04 5 31
Mark Noble 5 5 Midfielder West Ham United 35 1987-05-08 5 31
Aaron Ramsey 4 6 Midfielder Arsenal 31 1990-12-26 5 28
Jeffrey Schlupp 4 1 Defender Crystal Palace 29 1992-12-23 5 30
Jesse Lingard 4 2 Midfielder Manchester United 29 1992-12-15 5 27
Lucas Digne 4 4 Defender Everton 29 1993-07-20 5 35
Matt Doherty 4 5 Defender Wolverhampton Wanderers 30 1992-01-16 5 38
Nathan Aké 4 0 Defender AFC Bournemouth 27 1995-02-18 5 38
Nathaniel Mendez-Laing 4 1 Midfielder Cardiff City 30 1992-04-15 5 20
Pierre-Emile Højbjerg 4 3 Midfielder Southampton 27 1995-08-05 5 31
Harry Maguire 3 0 Defender Leicester City 29 1993-03-05 5 31
Johann Berg Guðmunds­son 3 6 Midfielder Burnley 32 1990-10-27 5 29
Alex Pritchard 2 0 Midfielder Huddersfield Town 29 1993-05-03 5 30
Calum Chambers 2 0 Defender Fulham 27 1995-01-20 5 31
José Luis Sanmartín Mato 2 0 Forward Newcastle United 32 1990-03-27 5 16
Lewis Dunk 2 1 Defender Brighton & Hove Albion 30 1991-11-21 5 36
Riyad Mahrez 7 4 Midfielder Manchester City 31 1991-02-21 6 27
Erik Lamela 4 2 Midfielder Tottenham Hotspur 30 1992-03-04 6 19
Granit Xhaka 4 2 Midfielder Arsenal 30 1992-09-27 6 29
N’Golo Kanté 4 4 Midfielder Chelsea 31 1991-03-29 6 36
Virgil van Dijk 4 2 Defender Liverpool 31 1991-07-08 6 38
Cenk Tosun 3 3 Forward Everton 31 1991-06-07 6 25
Craig Cathcart 3 0 Defender Watford 33 1989-02-06 6 36
Ivan Ricardo Neves Abreu Cavaleiro 3 1 Forward Wolverhampton Wanderers 29 1993-10-18 6 23
Jeff Hendrick 3 0 Midfielder Burnley 30 1992-01-31 6 32
Josh Murphy 3 2 Forward Cardiff City 27 1995-02-24 6 29
Juan Mata 3 2 Midfielder Manchester United 34 1988-04-28 6 22
Lucas Perez 3 0 Forward West Ham United 34 1988-09-10 6 15
Patrick van Aanholt 3 2 Defender Crystal Palace 32 1990-08-29 6 36
Stuart Armstrong 3 2 Midfielder Southampton 30 1992-03-30 6 29
Wes Morgan 3 0 Defender Leicester City 38 1984-01-21 6 22
Anthony Knockaert 2 6 Midfielder Brighton & Hove Albion 30 1991-11-20 6 30
Jefferson Lerma 2 0 Midfielder AFC Bournemouth 28 1994-10-25 6 30
Matt Ritchie 2 8 Midfielder Newcastle United 33 1989-09-10 6 36
Ryan Sessegnon 2 6 Defender Fulham 22 2000-05-18 6 35
Steve Mounié 2 3 Forward Huddersfield Town 28 1994-09-29 6 31
David Silva 6 8 Midfielder Manchester City 36 1986-01-08 7 33
David Junior Hoilett 3 1 Forward Cardiff City 32 1990-06-05 7 32
Divock Origi 3 1 Forward Liverpool 27 1995-04-18 7 12
Dwight McNeil 3 5 Forward Burnley 22 1999-11-22 7 21
Eric Dier 3 0 Midfielder Tottenham Hotspur 28 1994-01-15 7 20
James McArthur 3 6 Midfielder Crystal Palace 35 1987-10-07 7 38
José Holebas 3 6 Defender Watford 38 1984-06-27 7 28
Laurent Koscielny 3 0 Defender Arsenal 37 1985-09-10 7 17
Ross Barkley 3 5 Midfielder Chelsea 28 1993-12-05 7 27
Ander Herrera 2 3 Midfielder Manchester United 33 1989-08-14 7 22
Andriy Yarmolenko 2 0 Forward West Ham United 33 1989-10-23 7 9
Junior Stanislas 2 3 Midfielder AFC Bournemouth 32 1989-11-26 7 23
Jürgen Locadia 2 0 Forward Brighton & Hove Albion 28 1993-11-07 7 26
Kurt Zouma 2 2 Defender Everton 28 1994-10-27 7 32
Ricardo Domingos Barbosa Pereira 2 6 Defender Leicester City 29 1993-10-06 7 35
Romain Saïss 2 0 Midfielder Wolverhampton Wanderers 32 1990-03-26 7 19
Yann Valery 2 1 Defender Southampton 23 1999-02-22 7 23
Christian Atsu Twasam 1 0 Midfielder Newcastle United 30 1992-01-10 7 28
Jean Michau00ebl Seri 1 2 Midfielder Fulham 31 1991-07-19 7 32
Juninho Bacuna 1 0 Midfielder Huddersfield Town 25 1997-08-07 7 21
İlkay Gündoğan 6 3 Midfielder Manchester City 32 1990-10-24 8 31
Alex Iwobi 3 6 Forward Arsenal 26 1996-05-03 8 35
Georginio Wijnaldum 3 0 Midfielder Liverpool 31 1990-11-11 8 35
Willian 3 6 Forward Chelsea 34 1988-08-09 8 32
Ashley Westwood 2 7 Midfielder Burnley 32 1990-04-01 8 34
Charlie Austin 2 2 Forward Southampton 33 1989-07-05 8 25
Dan Gosling 2 1 Midfielder AFC Bournemouth 32 1990-02-01 8 25
Leander Dendoncker 2 0 Midfielder Wolverhampton Wanderers 27 1995-04-15 8 19
Marc Albrighton 2 2 Midfielder Leicester City 32 1989-11-18 8 27
Robert Snodgrass 2 5 Midfielder West Ham United 35 1987-09-07 8 33
Scott McTominay 2 0 Midfielder Manchester United 25 1996-12-08 8 16
Séamus Coleman 2 2 Defender Everton 34 1988-10-11 8 29
Will Hughes 2 4 Midfielder Watford 27 1995-04-17 8 32
Beram Kayal 1 1 Midfielder Brighton & Hove Albion 34 1988-05-02 8 18
Fernando Llorente Torres 1 4 Forward Tottenham Hotspur 37 1985-02-26 8 20
Jon Gorenc Stankovič 1 0 Defender Huddersfield Town 26 1996-01-14 8 11
Luciano Vietto 1 4 Forward Fulham 28 1993-12-05 8 20
Max Meyer 1 2 Midfielder Crystal Palace 27 1995-09-18 8 29
Sean Morrison 1 3 Defender Cardiff City 31 1991-01-08 8 34
Yoshinori Muto 1 0 Forward Newcastle United 30 1992-07-15 8 17
Aymeric Laporte 3 3 Defender Manchester City 28 1994-05-27 9 35
David Luiz 3 2 Defender Chelsea 35 1987-04-22 9 36
Ashley Young 2 2 Midfielder Manchester United 37 1985-07-09 9 30
Declan Rice 2 0 Midfielder West Ham United 23 1999-01-14 9 34
Naby Deco Keïta 2 1 Midfielder Liverpool 27 1995-02-10 9 25
Onyinye Wilfred Ndidi 2 0 Midfielder Leicester City 25 1996-12-16 9 38
Shkodran Mustafi 2 0 Defender Arsenal 30 1992-04-17 9 31
Aron Einar Gunnarsson 1 1 Midfielder Cardiff City 33 1989-04-22 9 28
Ben Gibson 1 0 Defender Burnley 29 1993-01-15 9 1
Christopher Schindler 1 0 Defender Huddersfield Town 32 1990-04-29 9 37
Dale Stephens 1 1 Midfielder Brighton & Hove Albion 33 1989-06-12 9 30
Etienne Capoue 1 3 Midfielder Watford 34 1988-07-11 9 33
Floyd Ayité 1 0 Midfielder Fulham 33 1988-12-15 9 16
Harry Winks 1 0 Midfielder Tottenham Hotspur 26 1996-02-02 9 26
Hélder Wander Sousa Azevedo Costa 1 2 Midfielder Wolverhampton Wanderers 28 1994-01-12 9 25
James Tomkins 1 1 Defender Crystal Palace 33 1989-03-29 9 29
Oriol Romeu 1 0 Midfielder Southampton 31 1991-09-24 9 31
Robert Kenedy Nunes do Nascimento 1 1 Midfielder Newcastle United 26 1996-02-08 9 25
Steve Cook 1 1 Defender AFC Bournemouth 31 1991-04-19 9 31
Yerry Fernando Mina González 1 0 Defender Everton 28 1994-09-23 9 13
Daniel Sturridge 2 1 Forward Liverpool 33 1989-09-01 10 18
Kevin De Bruyne 2 2 Midfielder Manchester City 31 1991-06-28 10 19
Lucas Torreira 2 2 Midfielder Arsenal 26 1996-02-11 10 34
Marcos Alonso 2 4 Defender Chelsea 31 1990-12-28 10 31
Aaron Lennon 1 1 Midfielder Burnley 35 1987-04-16 10 16
Adam Smith 1 1 Defender AFC Bournemouth 31 1991-04-29 10 25
Alexis Sanchez 1 3 Forward Manchester United 33 1988-12-19 10 20
Christian Benteke 1 1 Forward Crystal Palace 31 1990-12-03 10 16
Danny Ward 1 0 Forward Cardiff City 31 1990-12-09 10 14
Davy Pröpper 1 1 Midfielder Brighton & Hove Albion 31 1991-09-02 10 30
Fabián Cornelio Balbuena González 1 0 Defender West Ham United 31 1991-08-23 10 23
Harvey Lewis Barnes 1 2 Midfielder Leicester City 24 1997-12-09 10 16
Isaac Ajayi Success 1 1 Forward Watford 26 1996-01-07 10 30
Isaac Hayden 1 4 Midfielder Newcastle United 27 1995-03-22 10 25
Jan Vertonghen 1 0 Defender Tottenham Hotspur 35 1987-04-24 10 22
Mario Lemina 1 1 Midfielder Southampton 29 1993-09-01 10 21
Michael Keane 1 2 Defender Everton 29 1993-01-11 10 33
Ryan Bennett 1 0 Defender Wolverhampton Wanderers 32 1990-03-06 10 34
Terence Kongolo 1 1 Defender Huddersfield Town 28 1994-02-14 10 32
Tom Cairney 1 1 Midfielder Fulham 31 1991-01-20 10 31
Jorginho 2 0 Midfielder Chelsea 30 1991-12-20 11 37
André Filipe Tavares Gomes 1 1 Midfielder Everton 29 1993-07-30 11 27
Isaac Mbenza 1 1 Forward Huddersfield Town 26 1996-03-08 11 22
Jack Cork 1 2 Midfielder Burnley 33 1989-06-25 11 37
João Moutinho 1 8 Midfielder Wolverhampton Wanderers 36 1986-09-08 11 38
Joel Matip 1 0 Defender Liverpool 31 1991-08-08 11 22
Joel Ward 1 0 Defender Crystal Palace 32 1989-10-29 11 7
Jonny Evans 1 0 Defender Leicester City 34 1988-01-03 11 24
Kadeem Harris 1 0 Midfielder Cardiff City 29 1993-06-08 11 13
Lys Mousset 1 0 Forward AFC Bournemouth 26 1996-02-08 11 24
Matt Targett 1 3 Defender Southampton 27 1995-09-18 11 16
Nacho Monreal 1 3 Defender Arsenal 36 1986-02-26 11 22
Nemanja Matić 1 0 Midfielder Manchester United 34 1988-08-01 11 28
Philip Foden 1 0 Midfielder Manchester City 22 2000-05-28 11 13
Ryan Fredericks 1 0 Midfielder West Ham United 30 1992-10-10 11 15
Sean Longstaff 1 0 Midfielder Newcastle United 25 1997-10-30 11 9
Solomon March 1 5 Midfielder Brighton & Hove Albion 28 1994-07-20 11 35
Tom Cleverley 1 0 Midfielder Watford 33 1989-08-12 11 13
Victor Wanyama 1 0 Midfielder Tottenham Hotspur 31 1991-06-25 11 13
Alfie Mawson 0 0 Defender Fulham 28 1994-01-19 11 15
Olivier Giroud 2 4 Forward Chelsea 36 1986-09-30 12 27
Bernard Anício Caldeira Duarte 1 3 Midfielder Everton 30 1992-09-08 12 34
Charlie Daniels 1 0 Defender AFC Bournemouth 36 1986-09-07 12 21
Dejan Lovren 1 0 Defender Liverpool 33 1989-07-05 12 13
Francisco Femenía Far 1 1 Midfielder Watford 31 1991-02-02 12 29
Frederico Rodrigues Santos 1 1 Midfielder Manchester United 29 1993-03-05 12 17
Jonjo Shelvey 1 1 Midfielder Newcastle United 30 1992-02-27 12 16
Jonny 1 1 Defender Wolverhampton Wanderers 28 1994-03-03 12 33
Jordan Ayew 1 2 Forward Crystal Palace 31 1991-09-11 12 20
Kenneth Dahrup Zohorè 1 1 Forward Cardiff City 28 1994-01-31 12 19
Kieran Trippier 1 3 Defender Tottenham Hotspur 32 1990-09-19 12 27
Leon Balogun 1 0 Defender Brighton & Hove Albion 34 1988-06-28 12 8
Manolo Gabbiadini 1 0 Forward Southampton 30 1991-11-26 12 12
Manuel Lanzini 1 1 Midfielder West Ham United 29 1993-02-15 12 10
Matěj Vydra 1 1 Forward Burnley 30 1992-05-01 12 13
Rachid Ghezzal 1 0 Forward Leicester City 30 1992-05-09 12 19
Sokratis Papastathopoulos 1 2 Defender Arsenal 34 1988-06-09 12 25
Vincent Kompany 1 0 Defender Manchester City 36 1986-04-10 12 17
Elias Kachunga 0 0 Forward Huddersfield Town 30 1992-04-22 12 20
Tim Ream 0 0 Defender Fulham 35 1987-10-05 12 26
Adama Traoré Diarra 1 1 Midfielder Wolverhampton Wanderers 26 1996-01-25 13 29
Angelo Ogbonna 1 1 Defender West Ham United 34 1988-05-23 13 24
Antonio Rüdiger 1 0 Defender Chelsea 29 1993-03-03 13 33
Danilo 1 0 Defender Manchester City 31 1991-07-15 13 11
Danny Welbeck 1 1 Forward Arsenal 31 1990-11-26 13 8
Davinson Sánchez Mina 1 1 Defender Tottenham Hotspur 26 1996-06-12 13 23
DeAndre Yedlin 1 2 Defender Newcastle United 29 1993-07-09 13 29
Domingos Quina 1 0 Midfielder Watford 22 1999-11-18 13 8
Jordon Ibe 1 1 Midfielder AFC Bournemouth 26 1995-12-08 13 19
Kelechi Iheanacho 1 3 Forward Leicester City 26 1996-10-03 13 30
Luke Shaw 1 4 Defender Manchester United 27 1995-07-12 13 29
Phil Jagielka 1 0 Defender Everton 40 1982-08-17 13 7
Ryan Bertrand 1 0 Defender Southampton 33 1989-08-05 13 24
Trent Alexander-Arnold 1 12 Defender Liverpool 24 1998-10-07 13 29
Erik Durm 0 1 Defender Huddersfield Town 30 1992-05-12 13 28
Fabricio Martín Agosto Ramírez 0 0 Goalkeeper Fulham 34 1987-12-31 13 2
Martín Montoya 0 1 Defender Brighton & Hove Albion 31 1991-04-14 13 25
Oumar Niasse 0 0 Forward Cardiff City 32 1990-04-18 13 18
Robbie Brady 0 1 Midfielder Burnley 30 1992-01-14 13 16
Wayne Hennessey 0 0 Goalkeeper Crystal Palace 35 1987-01-24 13 18
Cesar Azpilicueta 1 5 Defender Chelsea 33 1989-08-28 14 38
Edward Nketiah 1 0 Forward Arsenal 23 1999-05-30 14 5
Issa Diop 1 0 Defender West Ham United 25 1997-01-09 14 33
Jack Stephens 1 0 Defender Southampton 28 1994-01-27 14 24
Jordan Henderson 1 3 Midfielder Liverpool 32 1990-06-17 14 32
Juan Marcos Foyth 1 0 Defender Tottenham Hotspur 24 1998-01-12 14 12
Ken Sema 1 2 Midfielder Watford 29 1993-09-30 14 17
Kyle Walker 1 1 Defender Manchester City 32 1990-05-28 14 33
Victor Nilsson Lindelöf 1 1 Defender Manchester United 28 1994-07-17 14 30
Ben Hamer 0 0 Goalkeeper Huddersfield Town 34 1987-11-20 14 7
David Button 0 0 Goalkeeper Brighton & Hove Albion 33 1989-02-27 14 4
Emerson Hyndman 0 0 Midfielder AFC Bournemouth 26 1996-04-09 14 1
Florian Lejeune 0 0 Defender Newcastle United 31 1991-05-20 14 12
Jordan Pickford 0 0 Goalkeeper Everton 28 1994-03-07 14 38
Leonardo Bonatini Lohner Maia 0 1 Forward Wolverhampton Wanderers 28 1994-03-28 14 7
Marcus Bettinelli 0 0 Goalkeeper Fulham 30 1992-05-24 14 7
Rhys Healey 0 0 Forward Cardiff City 27 1994-12-06 14 3
Scott Dann 0 1 Defender Crystal Palace 35 1987-02-14 14 10
Steven Defour 0 0 Midfielder Burnley 34 1988-04-15 14 6
Vicente Iborra De La Fuente 0 0 Midfielder Leicester City 34 1988-01-16 14 8
Ainsley Maitland-Niles 1 1 Midfielder Arsenal 25 1997-08-29 15 16
Cedric Soares 1 2 Defender Southampton 31 1991-08-31 15 18
Chris Smalling 1 0 Defender Manchester United 32 1989-11-22 15 24
Fabinho 1 2 Midfielder Liverpool 29 1993-10-23 15 28
Fernando Luiz Rosa 1 3 Midfielder Manchester City 37 1985-05-04 15 29
Adrien Sebastian Perruchet Silva 0 0 Midfielder Leicester City 33 1989-03-15 15 2
Collin Quaner 0 0 Forward Huddersfield Town 31 1991-06-18 15 2
Federico Fernández 0 1 Defender Newcastle United 33 1989-02-21 15 19
Gary Cahill 0 0 Defender Chelsea 36 1985-12-19 15 2
Håvard Nordtveit 0 1 Midfielder Fulham 32 1990-06-21 15 5
Jonjoe Kenny 0 1 Defender Everton 25 1997-03-15 15 10
Julián Speroni 0 0 Goalkeeper Crystal Palace 43 1979-05-18 15 1
Kevin Long 0 1 Defender Burnley 32 1990-08-18 15 6
Loïc Damour 0 0 Midfielder Cardiff City 31 1991-01-08 15 2
Marc Navarro Ceciliano 0 0 Defender Watford 27 1995-07-02 15 2
Mathew Ryan 0 0 Goalkeeper Brighton & Hove Albion 30 1992-04-08 15 34
Paulo Dino Gazzaniga 0 0 Goalkeeper Tottenham Hotspur 30 1992-01-02 15 3
Rúben Gonçalo Silva Nascimento Vinagre 0 0 Defender Wolverhampton Wanderers 23 1999-04-09 15 17
Sam Surridge 0 0 Forward AFC Bournemouth 24 1998-07-28 15 2
Samir Nasri 0 2 Midfielder West Ham United 35 1987-06-26 15 5
Andreas Pereira 1 1 Midfielder Manchester United 26 1996-01-01 16 15
Michael Obafemi 1 1 Forward Southampton 22 2000-07-06 16 6
Alexandre Nascimento Costa Silva 0 0 Forward West Ham United 25 1997-03-16 16 1
Alireza Jahanbakhsh 0 0 Forward Brighton & Hove Albion 29 1993-08-11 16 19
Alisson Becker 0 0 Goalkeeper Liverpool 30 1992-10-02 16 38
Antonio Barreca 0 0 Defender Newcastle United 27 1995-03-18 16 1
Ben Chilwell 0 4 Defender Leicester City 25 1996-12-21 16 36
Callum Hudson-Odoi 0 1 Midfielder Chelsea 21 2000-11-07 16 10
Connor Wickham 0 1 Forward Crystal Palace 29 1993-03-31 16 6
Dominic Solanke 0 1 Forward AFC Bournemouth 25 1997-09-14 16 10
Harry Arter 0 1 Midfielder Cardiff City 32 1989-12-28 16 25
Joe Hart 0 0 Goalkeeper Burnley 35 1987-04-19 16 19
Joel Coleman 0 0 Goalkeeper Huddersfield Town 27 1995-09-26 16 1
Joseph Willock 0 0 Midfielder Arsenal 23 1999-08-20 16 2
Lazar Marković 0 0 Midfielder Fulham 28 1994-03-02 16 1
Mason Holgate 0 0 Defender Everton 26 1996-10-22 16 5
Morgan Gibbs-White 0 1 Midfielder Wolverhampton Wanderers 22 2000-01-27 16 26
Nicolas Otamendi 0 0 Defender Manchester City 34 1988-02-12 16 18
Oliver Skipp 0 0 Midfielder Tottenham Hotspur 22 2000-09-16 16 8
Stefano Okaka 0 0 Forward Watford 33 1989-08-09 16 2
Ademola Lookman 0 2 Forward Everton 25 1997-10-20 17 21
Alberto Moreno 0 0 Defender Liverpool 30 1992-07-05 17 2
Alexander Sørloth 0 0 Forward Crystal Palace 26 1995-12-05 17 12
Andy Carroll 0 0 Forward West Ham United 33 1989-01-06 17 12
Ben Wilmot 0 0 Defender Watford 23 1999-11-04 17 2
Chris Mepham 0 1 Defender AFC Bournemouth 24 1997-11-05 17 13
Christian Fuchs 0 0 Defender Leicester City 36 1986-04-07 17 3
Danny Rose 0 3 Defender Tottenham Hotspur 32 1990-07-02 17 26
Demeaco Duhaney 0 0 Defender Huddersfield Town 24 1998-10-13 17 1
Denis Odoi 0 1 Defender Fulham 34 1988-05-27 17 31
Emerson Palmieri dos Santos 0 0 Defender Chelsea 28 1994-08-03 17 10
Jacob Murphy 0 1 Midfielder Newcastle United 27 1995-02-24 17 9
John Ruddy 0 0 Goalkeeper Wolverhampton Wanderers 36 1986-10-24 17 1
John Stones 0 0 Defender Manchester City 28 1994-05-28 17 24
José Diogo Dalot Teixeira 0 2 Defender Manchester United 23 1999-03-18 17 16
Neil Leonard Dula Etheridge 0 0 Goalkeeper Cardiff City 32 1990-02-07 17 38
Phil Bardsley 0 0 Defender Burnley 37 1985-06-28 17 19
Sam Gallagher 0 0 Forward Southampton 27 1995-09-15 17 4
Yves Bissouma 0 0 Midfielder Brighton & Hove Albion 26 1996-08-30 17 28
Adam David Lallana 0 0 Midfielder Liverpool 34 1988-05-10 18 13
Ben Foster 0 0 Goalkeeper Watford 39 1983-04-03 18 38
Benjamin Mendy 0 5 Defender Manchester City 28 1994-07-17 18 10
Callum Slattery 0 0 Midfielder Southampton 23 1999-02-08 18 3
Carl Jenkinson 0 0 Defender Arsenal 30 1992-02-08 18 3
Cesc Fabregas 0 0 Midfielder Chelsea 35 1987-05-04 18 6
Conor Coady 0 0 Midfielder Wolverhampton Wanderers 29 1993-02-25 18 38
David de Gea 0 0 Goalkeeper Manchester United 31 1990-11-07 18 38
Gaëtan Bong Songo 0 0 Defender Brighton & Hove Albion 34 1988-04-25 18 22
Georges-Kevin N’Koudou Mbida 0 1 Forward Tottenham Hotspur 27 1995-02-13 18 1
Grady Diangana 0 1 Midfielder West Ham United 24 1998-04-19 18 17
Jack Simpson 0 0 Defender AFC Bournemouth 25 1996-12-18 18 6
Jazz Richards 0 0 Defender Cardiff City 31 1991-04-12 18 4
Martin Dúbravka 0 0 Goalkeeper Newcastle United 33 1989-01-15 18 38
Martin Kelly 0 0 Defender Crystal Palace 32 1990-04-27 18 13
Matty Daly 0 0 Midfielder Huddersfield Town 21 2001-03-10 18 2
Nampalys Mendy 0 0 Midfielder Leicester City 30 1992-06-23 18 31
Neeskens Kebano 0 0 Midfielder Fulham 30 1992-03-10 18 7
Tom Davies 0 0 Midfielder Everton 24 1998-06-30 18 16
Tom Heaton 0 0 Goalkeeper Burnley 36 1986-04-15 18 19
André-Frank Zambo Anguissa 0 0 Midfielder Fulham 26 1995-11-16 19 22
Angel Gomes 0 0 Midfielder Manchester United 22 2000-08-31 19 2
Asmir Begović 0 0 Goalkeeper AFC Bournemouth 35 1987-06-20 19 24
Bruno Saltor Grau 0 1 Defender Brighton & Hove Albion 42 1980-10-01 19 14
Charlie Taylor 0 1 Defender Burnley 29 1993-09-18 19 38
Fabian Delph 0 1 Midfielder Manchester City 32 1989-11-21 19 11
Greg Cunningham 0 0 Defender Cardiff City 31 1991-01-31 19 7
Hugo Lloris 0 0 Goalkeeper Tottenham Hotspur 35 1986-12-26 19 33
Idrissa Gana Gueye 0 2 Midfielder Everton 33 1989-09-26 19 33
Jason Puncheon 0 0 Midfielder Huddersfield Town 36 1986-06-26 19 11
Javier Manquillo Gaitán 0 3 Defender Newcastle United 28 1994-05-05 19 18
Joe Gomez 0 0 Defender Liverpool 25 1997-05-23 19 16
Kayne Ramsey 0 0 Midfielder Southampton 22 2000-10-10 19 1
Konstantinos Mavropanos 0 0 Defender Arsenal 24 1997-12-11 19 4
Nathaniel Chalobah 0 0 Midfielder Watford 27 1994-12-12 19 9
Rui Pedro dos Santos Patrício 0 0 Goalkeeper Wolverhampton Wanderers 34 1988-02-15 19 37
Shinji Okazaki 0 1 Forward Leicester City 36 1986-04-16 19 21
Vicente Guaita 0 0 Goalkeeper Crystal Palace 35 1987-01-10 19 20
Wilfredo Daniel Caballero 0 0 Goalkeeper Chelsea 41 1981-09-28 19 2
Łukasz Fabiański 0 0 Goalkeeper West Ham United 37 1985-04-18 19 38
Aaron Cresswell 0 1 Defender West Ham United 32 1989-12-15 20 20
Adam Masina 0 1 Defender Watford 28 1994-01-02 20 14
Andrew Robertson 0 11 Defender Liverpool 28 1994-03-11 20 36
Artur Boruc 0 0 Goalkeeper AFC Bournemouth 42 1980-02-20 20 12
Bernardo 0 1 Defender Brighton & Hove Albion 27 1995-05-14 20 22
Caglar Söyüncü 0 0 Defender Leicester City 26 1996-05-23 20 6
Cheikhou Kouyaté 0 2 Midfielder Crystal Palace 32 1989-12-21 20 31
Gary Madine 0 0 Forward Cardiff City 32 1990-08-24 20 5
Ibrahima Cissé 0 0 Midfielder Fulham 28 1994-02-28 20 3
Joshua Sims 0 1 Midfielder Southampton 25 1997-03-28 20 7
Mateo Kovačić 0 2 Midfielder Chelsea 28 1994-05-06 20 32
Morgan Schneiderlin 0 1 Midfielder Everton 32 1989-11-08 20 14
Oleksandr Zinchenko 0 3 Midfielder Manchester City 25 1996-12-15 20 14
Petr Čech 0 0 Goalkeeper Arsenal 40 1982-05-20 20 7
Ramadan Sobhi 0 0 Forward Huddersfield Town 25 1997-01-23 20 4
Stephen Ward 0 0 Defender Burnley 37 1985-08-20 20 3
Sung-Yeung Ki 0 1 Midfielder Newcastle United 33 1989-01-24 20 18
Tahith Chong 0 0 Forward Manchester United 22 1999-12-04 20 2
Toby Alderweireld 0 0 Defender Tottenham Hotspur 33 1989-03-02 20 34
Adrian Mariappa 0 0 Defender Watford 36 1986-10-03 21 26
Alex McCarthy 0 0 Goalkeeper Southampton 32 1989-12-03 21 25
Alex Oxlade-Chamberlain 0 0 Midfielder Liverpool 29 1993-08-15 21 2
Andreas Christensen 0 0 Defender Chelsea 26 1996-04-10 21 8
Ben Mee 0 2 Defender Burnley 33 1989-09-21 21 38
Carlos Sánchez 0 0 Midfielder West Ham United 36 1986-02-06 21 7
Daniel Williams 0 0 Midfielder Huddersfield Town 33 1989-03-08 21 5
Danny Simpson 0 0 Defender Leicester City 35 1987-01-04 21 6
Diego Rico 0 0 Defender AFC Bournemouth 29 1993-02-23 21 12
Ederson 0 1 Goalkeeper Manchester City 29 1993-08-17 21 38
Faustino Marcos Alberto Rojo 0 0 Defender Manchester United 32 1990-03-20 21 5
Jose Izquierdo 0 1 Forward Brighton & Hove Albion 30 1992-07-07 21 15
Kyle Walker-Peters 0 3 Defender Tottenham Hotspur 25 1997-04-13 21 6
Lee Peltier 0 0 Defender Cardiff City 35 1986-12-11 21 20
Leighton Baines 0 0 Defender Everton 37 1984-12-11 21 6
Mamadou Sakho 0 0 Defender Crystal Palace 32 1990-02-13 21 27
Mohamed Diamé 0 0 Midfielder Newcastle United 35 1987-06-14 21 29
Mohamed Elneny 0 0 Midfielder Arsenal 30 1992-07-11 21 8
Sergio Rico 0 0 Goalkeeper Fulham 29 1993-09-01 21 29
Aaron Wan-Bissaka 0 3 Midfielder Crystal Palace 24 1997-11-26 22 35
Abdelhamid Sabiri 0 0 Midfielder Huddersfield Town 25 1996-11-28 22 2
Davide Zappacosta 0 0 Defender Chelsea 30 1992-06-11 22 4
Fousseni Diabaté 0 0 Midfielder Leicester City 27 1995-10-18 22 1
James McCarthy 0 0 Midfielder Everton 31 1990-11-12 22 1
Joe Ralls 0 0 Midfielder Cardiff City 29 1993-10-13 22 28
Marouane Fellaini 0 1 Midfielder Manchester United 34 1987-11-22 22 14
Matthew Lowton 0 0 Defender Burnley 33 1989-06-09 22 21
Michel Vorm 0 0 Goalkeeper Tottenham Hotspur 39 1983-10-20 22 2
Nathaniel Clyne 0 1 Defender AFC Bournemouth 31 1991-04-05 22 18
Paul Dummett 0 0 Defender Newcastle United 31 1991-09-26 22 26
Pedro Obiang 0 1 Midfielder West Ham United 30 1992-03-27 22 24
Sead Kolašinac 0 5 Defender Arsenal 29 1993-06-20 22 24
Sebastian Prödl 0 0 Defender Watford 35 1987-06-21 22 1
Steven Davis 0 1 Midfielder Southampton 37 1985-01-01 22 3
Timothy Fosu-Mensah 0 0 Defender Fulham 24 1998-01-02 22 12
Antonio Valencia 0 0 Defender Manchester United 37 1985-08-04 23 6
Bakary Sako 0 0 Midfielder Crystal Palace 34 1988-04-26 23 4
Bernd Leno 0 0 Goalkeeper Arsenal 30 1992-03-04 23 32
Daryl Janmaat 0 2 Defender Watford 33 1989-07-22 23 18
Hamza Choudhury 0 0 Midfielder Leicester City 25 1997-10-01 23 9
Jamal Lascelles 0 1 Defender Newcastle United 28 1993-11-11 23 32
Joe Bennett 0 1 Defender Cardiff City 32 1990-03-28 23 30
Luke Amos 0 0 Midfielder Tottenham Hotspur 25 1997-02-23 23 1
Maxime Le Marchand 0 1 Defender Fulham 33 1989-10-11 23 26
Maya Yoshida 0 1 Defender Southampton 34 1988-08-24 23 17
Pablo Zabaleta 0 1 Defender West Ham United 37 1985-01-16 23 26
Peter Crouch 0 0 Forward Burnley 41 1981-01-30 23 6
Rajiv van La Parra 0 0 Midfielder Huddersfield Town 31 1991-06-04 23 5
Tyrone Mings 0 0 Defender AFC Bournemouth 29 1993-03-13 23 5
Victor Moses 0 0 Midfielder Chelsea 31 1990-12-12 23 2
Bruno Écuélé Manga 0 1 Defender Cardiff City 34 1988-07-16 24 38
Christian Kabasele 0 0 Defender Watford 31 1991-02-24 24 21
Daniel Amartey 0 0 Midfielder Leicester City 27 1994-12-21 24 9
Jack Wilshere 0 1 Midfielder West Ham United 30 1992-01-01 24 8
Jan Bednarek 0 1 Defender Southampton 26 1996-04-12 24 25
Kepa Arrizabalaga 0 0 Goalkeeper Chelsea 28 1994-10-03 24 36
Lewis Cook 0 0 Midfielder AFC Bournemouth 25 1997-02-03 24 13
Miguel Ángel Almirón Rejala 0 0 Midfielder Newcastle United 28 1994-02-10 24 10
Moussa Dembele 0 0 Midfielder Tottenham Hotspur 35 1987-07-16 24 10
Phil Jones 0 1 Defender Manchester United 30 1992-02-21 24 18
Rob Holding 0 0 Defender Arsenal 27 1995-09-20 24 10
Stefan Marius Johansen 0 0 Midfielder Fulham 31 1991-01-08 24 12
Tom Smith 0 0 Defender Huddersfield Town 30 1992-04-14 24 15
Angus Gunn 0 0 Goalkeeper Southampton 26 1996-01-22 25 12
Arthur Masuaku 0 1 Defender West Ham United 28 1993-11-07 25 23
Jermain Defoe 0 0 Forward AFC Bournemouth 40 1982-10-07 25 4
Jonas Lössl 0 1 Goalkeeper Huddersfield Town 33 1989-02-01 25 31
Kasper Schmeichel 0 0 Goalkeeper Leicester City 35 1986-11-05 25 38
Kevin McDonald 0 0 Midfielder Fulham 33 1988-11-04 25 15
Leandro Bacuna 0 0 Midfielder Cardiff City 31 1991-08-21 25 11
Matteo Darmian 0 0 Defender Manchester United 32 1989-12-02 25 6
Miguel Ángel Britos Cabrera 0 0 Defender Watford 37 1985-07-17 25 3
Moussa Sissoko 0 3 Midfielder Tottenham Hotspur 33 1989-08-16 25 29
Stephan Lichtsteiner 0 0 Defender Arsenal 38 1984-01-16 25 14
Adama Diakhaby 0 0 Forward Huddersfield Town 26 1996-07-05 26 12
Ben Davies 0 0 Defender Tottenham Hotspur 29 1993-04-24 26 27
Benjamin Johnson 0 0 Forward West Ham United 22 2000-01-24 26 1
Eric Bertrand Bailly 0 0 Defender Manchester United 28 1994-04-12 26 12
Joe Bryan 0 1 Defender Fulham 29 1993-09-17 26 28
Mattéo Guendouzi Olié 0 0 Midfielder Arsenal 23 1999-04-14 26 33
Mohamed Elyounoussi 0 0 Midfielder Southampton 28 1994-08-04 26 16
Simon Francis 0 2 Defender AFC Bournemouth 37 1985-02-16 26 17
Andrew Surman 0 0 Midfielder AFC Bournemouth 36 1986-08-20 27 18
Cyrus Christie 0 1 Defender Fulham 30 1992-09-30 27 28
Hector Bellerin 0 5 Defender Arsenal 27 1995-03-19 27 19
Laurent Depoitre 0 1 Forward Huddersfield Town 33 1988-12-07 27 23
Mason Greenwood 0 0 Midfielder Manchester United 21 2001-10-01 27 3
Serge Aurier 0 2 Defender Tottenham Hotspur 29 1992-12-24 27 8
Wesley Hoedt 0 0 Defender Southampton 28 1994-03-06 27 13
Denis Suárez 0 0 Midfielder Arsenal 28 1994-01-06 28 4
Jannik Vestergaard 0 0 Defender Southampton 30 1992-08-03 28 23
Jonathan Hogg 0 1 Midfielder Huddersfield Town 33 1988-12-06 28 29
Mark Travers 0 0 Goalkeeper AFC Bournemouth 23 1999-05-18 28 2
Vincent Janssen 0 0 Forward Tottenham Hotspur 28 1994-06-15 28 3
Florent Hadergjonaj 0 0 Defender Huddersfield Town 28 1994-07-31 29 24
Fraser Forster 0 0 Goalkeeper Southampton 34 1988-03-17 29 1
Chris Löwe 0 2 Defender Huddersfield Town 33 1989-04-16 30 29
Aaron Rowe 0 0 Forward Huddersfield Town 22 2000-09-07 31 2

Best Goalie

A Goalie much like the defender is the last line of defence against the ball. The clean sheets in the end all rely on them.

Goalie <- filter(df, position == "Goalkeeper") %>% 
  select(c('full_name','clean_sheets_overall','position','current_club','age','birthday_gmt', 'appearances_overall' ))

GoalieClean <- Goalie[order(-Goalie$clean_sheets_overall),]

kable(GoalieClean, format = "html" , caption = "Top league Goalies",align = "cccccccccccccccc") %>% kable_styling()
Top league Goalies
full_name clean_sheets_overall position current_club age birthday_gmt appearances_overall
Alisson Becker 21 Goalkeeper Liverpool 30 1992-10-02 38
Ederson 20 Goalkeeper Manchester City 29 1993-08-17 38
Jordan Pickford 14 Goalkeeper Everton 28 1994-03-07 38
Kepa Arrizabalaga 14 Goalkeeper Chelsea 28 1994-10-03 36
Hugo Lloris 12 Goalkeeper Tottenham Hotspur 35 1986-12-26 33
Martin Dúbravka 11 Goalkeeper Newcastle United 33 1989-01-15 38
Kasper Schmeichel 10 Goalkeeper Leicester City 35 1986-11-05 38
Neil Leonard Dula Etheridge 10 Goalkeeper Cardiff City 32 1990-02-07 38
Rui Pedro dos Santos Patrício 8 Goalkeeper Wolverhampton Wanderers 34 1988-02-15 37
Ben Foster 7 Goalkeeper Watford 39 1983-04-03 38
Bernd Leno 7 Goalkeeper Arsenal 30 1992-03-04 32
David de Gea 7 Goalkeeper Manchester United 31 1990-11-07 38
Vicente Guaita 7 Goalkeeper Crystal Palace 35 1987-01-10 20
Łukasz Fabiański 7 Goalkeeper West Ham United 37 1985-04-18 38
Mathew Ryan 6 Goalkeeper Brighton & Hove Albion 30 1992-04-08 34
Asmir Begović 5 Goalkeeper AFC Bournemouth 35 1987-06-20 24
Jonas Lössl 5 Goalkeeper Huddersfield Town 33 1989-02-01 31
Sergio Rico 5 Goalkeeper Fulham 29 1993-09-01 29
Wayne Hennessey 5 Goalkeeper Crystal Palace 35 1987-01-24 18
Alex McCarthy 4 Goalkeeper Southampton 32 1989-12-03 25
Artur Boruc 4 Goalkeeper AFC Bournemouth 42 1980-02-20 12
Joe Hart 4 Goalkeeper Burnley 35 1987-04-19 19
Tom Heaton 4 Goalkeeper Burnley 36 1986-04-15 19
Angus Gunn 3 Goalkeeper Southampton 26 1996-01-22 12
Petr Čech 2 Goalkeeper Arsenal 40 1982-05-20 7
Wilfredo Daniel Caballero 2 Goalkeeper Chelsea 41 1981-09-28 2
Ben Hamer 1 Goalkeeper Huddersfield Town 34 1987-11-20 7
David Button 1 Goalkeeper Brighton & Hove Albion 33 1989-02-27 4
John Ruddy 1 Goalkeeper Wolverhampton Wanderers 36 1986-10-24 1
Mark Travers 1 Goalkeeper AFC Bournemouth 23 1999-05-18 2
Paulo Dino Gazzaniga 1 Goalkeeper Tottenham Hotspur 30 1992-01-02 3
Will Norris 1 Goalkeeper Wolverhampton Wanderers 29 1993-08-12 1
Adrián San Miguel del Castillo 0 Goalkeeper West Ham United 35 1987-01-03 0
Alex Smithies 0 Goalkeeper Cardiff City 32 1990-03-05 0
Alfie Whiteman 0 Goalkeeper Tottenham Hotspur 24 1998-10-02 0
Arijanet Muric 0 Goalkeeper Manchester City 23 1998-11-07 0
Brian Murphy 0 Goalkeeper Cardiff City 39 1983-05-07 0
Claudio Andrés Bravo Muñoz 0 Goalkeeper Manchester City 39 1983-04-13 0
Damián Emiliano Martínez 0 Goalkeeper Arsenal 30 1992-09-02 0
Danny Ward 0 Goalkeeper Leicester City 29 1993-06-22 0
Fabricio Martín Agosto Ramírez 0 Goalkeeper Fulham 34 1987-12-31 2
Fraser Forster 0 Goalkeeper Southampton 34 1988-03-17 1
Freddie Woodman 0 Goalkeeper Newcastle United 25 1997-03-04 0
Heurelho da Silva Gomes 0 Goalkeeper Watford 41 1981-02-15 0
Jason Steele 0 Goalkeeper Brighton & Hove Albion 32 1990-08-18 0
Joe Daniel Tupper 0 Goalkeeper Crystal Palace 24 1997-11-15 0
Joel Coleman 0 Goalkeeper Huddersfield Town 27 1995-09-26 1
Julián Speroni 0 Goalkeeper Crystal Palace 43 1979-05-18 1
Karl Darlow 0 Goalkeeper Newcastle United 32 1990-10-08 0
Lee Grant 0 Goalkeeper Manchester United 39 1983-01-27 0
Loris Karius 0 Goalkeeper Liverpool 29 1993-06-22 0
Maarten Stekelenburg 0 Goalkeeper Everton 40 1982-09-22 0
Marcus Bettinelli 0 Goalkeeper Fulham 30 1992-05-24 7
Michel Vorm 0 Goalkeeper Tottenham Hotspur 39 1983-10-20 2
Ryan Schofield 0 Goalkeeper Huddersfield Town 22 1999-12-11 0
Sergio Germán Romero 0 Goalkeeper Manchester United 35 1987-02-22 0
Simon Mignolet 0 Goalkeeper Liverpool 34 1988-03-06 0

Winning Team

League Rankings

This graph shows the winning team of the league and later on shows the goals they scored giving more context as to why they were ranked this way.

dfTeams %>% 
  ggplot(aes(x= reorder(common_name,+league_position) ,y= league_position )) +
  geom_col() + theme(axis.text.x = element_text(angle = 90)) + labs(x = "Club Name",
                                                                    y = "League Position")

League Ranking Stats

dfWin <- filter(dfTeams) %>% select(c('common_name', 'league_position','performance_rank','goals_scored','goals_conceded',
                                     'goal_difference','matches_played', 'wins' , 'draws', 
                                     'losses', 'points_per_game'  )) 

winClean <- dfWin[order(dfWin$league_position),]

kable(winClean, format = "html" , caption = "Team Performance",align = "ccccccccccc") %>% kable_styling()
Team Performance
common_name league_position performance_rank goals_scored goals_conceded goal_difference matches_played wins draws losses points_per_game
Manchester City 1 1 95 23 72 38 32 2 4 2.58
Liverpool 2 2 89 22 67 38 30 7 1 2.55
Chelsea 3 3 63 39 24 38 21 9 8 1.89
Tottenham Hotspur 4 4 67 39 28 38 23 2 13 1.87
Arsenal 5 5 73 51 22 38 21 7 10 1.84
Manchester United 6 6 65 54 11 38 19 9 10 1.74
Wolverhampton Wanderers 7 7 47 46 1 38 16 9 13 1.50
Everton 8 8 54 46 8 38 15 9 14 1.42
Leicester City 9 9 51 48 3 38 15 7 16 1.37
West Ham United 10 10 52 55 -3 38 15 7 16 1.37
Watford 11 11 52 59 -7 38 14 8 16 1.32
Crystal Palace 12 12 51 53 -2 38 14 7 17 1.29
Newcastle United 13 13 42 48 -6 38 12 9 17 1.18
AFC Bournemouth 14 14 56 70 -14 38 13 6 19 1.18
Burnley 15 15 45 68 -23 38 11 7 20 1.05
Southampton 16 16 45 65 -20 38 9 12 17 1.03
Brighton & Hove Albion 17 17 35 60 -25 38 9 9 20 0.95
Cardiff City 18 18 34 69 -35 38 10 4 24 0.89
Fulham 19 19 34 81 -47 38 7 5 26 0.68
Huddersfield Town 20 20 22 76 -54 38 3 7 28 0.42

Goal Difference by League Position

dfTeams %>% 
  ggplot(aes(x= league_position ,y= goal_difference, fill = common_name)) +
  geom_col()

Goals Overall By League Position

dfTeams %>% 
  ggplot(aes(x= league_position ,y= goals_scored, fill = common_name)) +
  geom_col()

Who’s Gonna Win?

This section is the most special to me and I think a very interesting part of statistics and football. This is a machine learning program that in theory should be able to predict who should win a game. This is not necessarily 100 percent accurate prediction but the main thing is to deter bookies from scamming odds.

H_df<-dfMatches%>%select(-date_gmt, -away_team_name)%>%
      group_by(status, home_team_name)%>%arrange(game_week)%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(lag))%>%
      na.omit()%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(cummean))%>%
      select(-away_ppg)%>%ungroup()
## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
## Warning: There were 40 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `home_team_goal_timings = cummean(home_team_goal_timings)`.
## ℹ In group 1: `status = "complete"`, `home_team_name = "AFC Bournemouth"`.
## Caused by warning in `cummean()`:
## ! NAs introduced by coercion
## ℹ Run ]8;;ide:run:dplyr::last_dplyr_warnings()dplyr::last_dplyr_warnings()]8;; to see the 39 remaining warnings.
colnames(H_df)<-paste("H", colnames(H_df), sep = "_")

A_df<-dfMatches%>%select(-date_gmt, -home_team_name)%>%
      group_by(status, away_team_name)%>%arrange(game_week)%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(lag))%>%
      na.omit()%>%
      mutate_at(vars(home_team_goal_count:average_goals_per_match_pre_match), funs(cummean))%>%
      select(-home_ppg)%>%ungroup()
## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
## Warning: `funs()` was deprecated in dplyr 0.8.0.
## ℹ Please use a list of either functions or lambdas:
## 
## # Simple named list: list(mean = mean, median = median)
## 
## # Auto named with `tibble::lst()`: tibble::lst(mean, median)
## 
## # Using lambdas list(~ mean(., trim = .2), ~ median(., na.rm = TRUE))
## Call `lifecycle::last_lifecycle_warnings()` to see where this warning was
## generated.
## Warning: There were 40 warnings in `mutate()`.
## The first warning was:
## ℹ In argument: `home_team_goal_timings = cummean(home_team_goal_timings)`.
## ℹ In group 1: `status = "complete"`, `away_team_name = "AFC Bournemouth"`.
## Caused by warning in `cummean()`:
## ! NAs introduced by coercion
## ℹ Run ]8;;ide:run:dplyr::last_dplyr_warnings()dplyr::last_dplyr_warnings()]8;; to see the 39 remaining warnings.
colnames(A_df)<-paste("A", colnames(A_df), sep = "_")

results_df <- dfMatches %>% select(game_week, status, home_team_name, away_team_name, home_team_goal_count, away_team_goal_count)

final_df <- results_df %>% inner_join(H_df, by=c("home_team_name"="H_home_team_name")) %>% inner_join(A_df, by=c("away_team_name"="A_away_team_name"))
## Warning in inner_join(., H_df, by = c(home_team_name = "H_home_team_name")): Each row in `x` is expected to match at most 1 row in `y`.
## ℹ Row 1 of `x` matches multiple rows.
## ℹ If multiple matches are expected, set `multiple = "all"` to silence this
##   warning.
## Warning in inner_join(., A_df, by = c(away_team_name = "A_away_team_name")): Each row in `x` is expected to match at most 1 row in `y`.
## ℹ Row 1 of `x` matches multiple rows.
## ℹ If multiple matches are expected, set `multiple = "all"` to silence this
##   warning.
h2o.init()
##  Connection successful!
## 
## R is connected to the H2O cluster: 
##     H2O cluster uptime:         6 hours 36 minutes 
##     H2O cluster timezone:       America/Denver 
##     H2O data parsing timezone:  UTC 
##     H2O cluster version:        3.40.0.1 
##     H2O cluster version age:    2 months and 23 days 
##     H2O cluster name:           H2O_started_from_R_ethanwilsher_haa191 
##     H2O cluster total nodes:    1 
##     H2O cluster total memory:   2.80 GB 
##     H2O cluster total cores:    8 
##     H2O cluster allowed cores:  8 
##     H2O cluster healthy:        TRUE 
##     H2O Connection ip:          localhost 
##     H2O Connection port:        54321 
##     H2O Connection proxy:       NA 
##     H2O Internal Security:      FALSE 
##     R Version:                  R version 4.2.3 (2023-03-15)
Train <- final_df%>%filter(game_week <= 38, game_week >= 3)

Test <- final_df%>%filter(game_week >= 20)

Train_h2o <- as.h2o(Train)
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |======================================================================| 100%
Test_h2o <- as.h2o(Test)
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |======================================================================| 100%
aml <- h2o.automl(y = 5,  x=6:62, training_frame = Train_h2o,   leaderboard_frame  = Test_h2o, max_runtime_secs = 60)
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |=                                                                     |   2%
## 01:21:30.23: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |====                                                                  |   5%
  |                                                                            
  |======                                                                |   8%
## 01:21:34.512: _train param, Dropping bad and constant columns: [H_referee, H_status]
## 01:21:34.733: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |========                                                              |  12%
## 01:21:36.812: _train param, Dropping unused columns: [H_referee, H_status]
## 01:21:37.256: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |===========                                                           |  15%
  |                                                                            
  |=============                                                         |  19%
## 01:21:40.796: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |===============                                                       |  22%
## 01:21:42.974: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |==================                                                    |  25%
## 01:21:44.486: _train param, Dropping bad and constant columns: [H_referee, H_status]
## 01:21:46.150: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |====================                                                  |  29%
## 01:21:48.12: _train param, Dropping unused columns: [H_referee, H_status]
  |                                                                            
  |=======================                                               |  32%
## 01:21:48.522: _train param, Dropping unused columns: [H_referee, H_status]
## 01:21:49.97: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |=========================                                             |  36%
## 01:21:52.386: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |===========================                                           |  39%
  |                                                                            
  |==============================                                        |  43%
## 01:21:55.21: _train param, Dropping bad and constant columns: [H_referee, H_status]
  |                                                                            
  |================================                                      |  46%
## 01:21:56.588: _train param, Dropping bad and constant columns: [H_referee, H_status]
## 01:21:57.481: _train param, Dropping unused columns: [H_referee, H_status]
## 01:21:57.922: _train param, Dropping unused columns: [H_referee, H_status]
  |                                                                            
  |===================================                                   |  49%
  |                                                                            
  |=====================================                                 |  53%
  |                                                                            
  |=======================================                               |  56%
  |                                                                            
  |==========================================                            |  59%
  |                                                                            
  |============================================                          |  63%
  |                                                                            
  |==============================================                        |  66%
  |                                                                            
  |=================================================                     |  70%
  |                                                                            
  |===================================================                   |  73%
  |                                                                            
  |======================================================                |  76%
  |                                                                            
  |========================================================              |  80%
  |                                                                            
  |==========================================================            |  83%
  |                                                                            
  |=============================================================         |  87%
  |                                                                            
  |===============================================================       |  90%
  |                                                                            
  |==================================================================    |  94%
  |                                                                            
  |====================================================================  |  97%
## 01:22:27.847: _train param, Dropping unused columns: [H_referee, H_status]
## 01:22:28.303: _train param, Dropping unused columns: [H_referee, H_status]
  |                                                                            
  |======================================================================| 100%
lb <- aml@leaderboard

pred <- h2o.predict(aml@leader, Test_h2o)
## 
  |                                                                            
  |                                                                      |   0%
  |                                                                            
  |======================================================================| 100%
h2o.performance(model = aml@leader, newdata = Train_h2o)
## H2ORegressionMetrics: gbm
## 
## MSE:  1.06661
## RMSE:  1.032768
## MAE:  0.7779809
## RMSLE:  0.4298544
## Mean Residual Deviance :  1.06661

Am I A Good Player?

In this section there are 4 graphs that show a correlation between how many goals someone should score and how good they should be.

mod1 <- glm(data = df,
            formula = goals_overall ~ age + current_club + assists_overall + red_cards_overall + minutes_played_overall + clean_sheets_overall)

mod2 <- glm(data = df,
            formula = goals_overall ~ age * current_club * assists_overall * red_cards_overall * minutes_played_overall * clean_sheets_overall)

compare_performance(mod1,mod2) %>% plot()

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x=age, y= pred)) +
          geom_smooth() + labs(title = "Age")

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x=assists_overall, y = pred)) +
          geom_smooth() + labs(title = "Assists")

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x = minutes_played_overall, y = pred)) +
          geom_smooth() + labs(title = "Minutes Played")

add_predictions(df, mod2, type = "response") %>% 
  ggplot(aes(x=clean_sheets_overall, y = pred)) +
          geom_smooth() + labs(title = "Clean Sheets")

Takeaway

My take away from studying the data is that it can be really easy to talk about who is at the top of the league and who is scoring the most just by reading a table but there is a lot more that the data does not flat out tell you. So my advice is if you want to talk to people about football just watch a bit and ask questions. There also is a lot of things that they do not collect for data but speak of more in passing like passes and time ball was controlled.